View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Macros and Menu Command

record a macro to add and one to delete the menu item
in the workbook you want it on put the install in on startup and the delete
on close

"mary" wrote:

I recorded a simple macro and saved it only in a specific workbook. I placed
a menu command on that toolbar.

Now every workbook I open has the menu command in it and when I click the
menu command that appears in a workbook where it shouldn't, it automatically
opens up the worksheet that the macro was originally designed for.

How can I save the recorded macro and menu command only in one workbook and
be sure that it doesn't appear anywhere else?