chamster
09-04-2007, 11:16 PM
I tried to place a method called blopp by adding the following (roughly).
Private Sub blopp ()
MsgBox "!"
End Sub
When i put the code into one of the modules, it works as supposed to (it's connected to a WordArt-object on clicking). But when i move it to the sheet on which i placed the WordArt-object i get "no method found" or something similar as complaint. Suggestions?
If it's not fixable the way i'd like then i've got an other approach. How can i rename the modules that Excel places macros in? I can have my code there but it's dangerous to have it called "Module4" due to deletion risk. I'd prefer to name such a module "Konrad_Modus" or something else more fun and personal.
Private Sub blopp ()
MsgBox "!"
End Sub
When i put the code into one of the modules, it works as supposed to (it's connected to a WordArt-object on clicking). But when i move it to the sheet on which i placed the WordArt-object i get "no method found" or something similar as complaint. Suggestions?
If it's not fixable the way i'd like then i've got an other approach. How can i rename the modules that Excel places macros in? I can have my code there but it's dangerous to have it called "Module4" due to deletion risk. I'd prefer to name such a module "Konrad_Modus" or something else more fun and personal.