Assigning macro [names] question

[justme]

I have a series of macros in one workbook. When I assign them to a button the macro name is shown. On the last two macros I made when I go to assign them to a button I see the name of the file with a "!" after it, then the macro name followed by a "."Then the macro name again. What did I do?

I know I copied an existing macro to modify to make the new ones, but why the wierd names? How can I change so it offers only the macro name?

 

[erik.van.geit]

Hi, justme
(or should I say justyou )

be happy the list is showing the workbooknames, so you're sure where they are
when you've only one workbook open then the workbooknames don't appear

or do you need something else ?
why would you not like to see those workbooknames ?

kind regards,
Erik

 

[justme]

Hello Erik

I have only the one workbook open. When I click the assign macro button some macros show only their name and the two in question list a file name along with the macro name.

 

[erik.van.geit]

another filename ?

then you did assign the buttons to another workbook
or you copied them from another workbook
or you renamed the workbook (don't know if this is a possible reason

you will have to delete the workbook-part of the assignment

to avoid future problems don't let the workbookname in the assignment when you link macros to your buttons

a workaround could be
rename the workbook to the one the buttons are assigned to
(temporarely move or rename the other one)
save
rename again

this worked for me !!

kind regards,
Erik

 

[justme]

THanks, will try your work around this afternoon.

 

[erik.van.geit]

OK, please let me know for future reference

 

[justme]

Is there a proper method to copy an existing module because your new one is going to be very similar? I copied the code then I inserted a new module and pasted the code. Then I changed the name of the Sub() routine and the name in the properties window.

 

[erik.van.geit]

My trick - using often for userforms - is

open new workbook
in VBAwindow
drag module or form to other project
drag it back to the original
form has to be renamed first
module is renaming automatically

 

[justme]

That makes a lot of sense and is easy too. I will try this next time.