PDA

View Full Version : Placement of a method



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.

vksingh24
09-04-2007, 11:55 PM
1. click on your module
2. Press F4 to bringh up the properties window
3. Change the name from module4 to whatever you want to rename it

chamster
09-05-2007, 12:09 AM
Sometimes i DO be retarded. Thanks!

There should be an option of right clicking as well.