Workbooks and custom menus

[Guest]

Previous versions of Excel (such as 95) used to be able to let you define a custom menu which would operate for that workbook only, and then close the custom menu item when you closed that workbook and opened up another (unrelated) Excel file. With the Excel 2002 that I have, I'm having a hard time trying to figure out how to get my custom menu to just work with one particular workbook and not appear on other, unrelated workbooks. For example, let's say I want a custom menu to appear on File1.xls, but not in File2.xls. Also, if I give a friend a copy of File1, I want him/her to see it too, so I would like everything (workbook + custom menu) to be located in the SAME workbook file, not some *.xlb file somewhere out there which everyone would forget to copy. Used to be, you could save everything, menu included, in the same workbook file. Nowadays, with Microsoft's so-called "improvements" to Excel they seem to have taken this capability away. As per usual, Excel's on-line "help" is absolutely no help at all and confuses me even further. If anyone has any suggestions on how to fix this, please respond to this email. Thanks.

 

[Larry Daugherty]

Hi Jeffa,

I may be all wrong but I believe you need to put code indo the one workbook
to enable that special menu and to remove it when you close the workbook.
You probably had that code in the Excel 95 version as well but may have
imported just the menu.


HTH
--
-Larry-
--

Previous versions of Excel (such as 95) used to be able to let you define

a custom menu which would operate for that workbook only, and then close the
custom menu item when you closed that workbook and opened up another
(unrelated) Excel file. With the Excel 2002 that I have, I'm having a hard
time trying to figure out how to get my custom menu to just work with one
particular workbook and not appear on other, unrelated workbooks. For
example, let's say I want a custom menu to appear on File1.xls, but not in
File2.xls. Also, if I give a friend a copy of File1, I want him/her to see
it too, so I would like everything (workbook + custom menu) to be located in
the SAME workbook file, not some *.xlb file somewhere out there which
everyone would forget to copy. Used to be, you could save everything, menu
included, in the same workbook file. Nowadays, with Microsoft's so-called
"improvements" to Excel they seem to have taken this capability away. As per
usual, Excel's on-line "help" is absolutely no help at all and confuses me
even further. If anyone has any suggestions on how to fix this, please
respond to this email. Thanks.

 

[BrianB]

There is an option in the toolbar/customize menu to attach a toolbar to a workbook.

Regards
BrianB
==============================================================