Working with and adding Menus?
 

I have created a template and I have added a custom menu to perform some
common tasks.

1. Is there a way to make the menu only accessible to this spreadsheet
and not others that are open?

2. If I have multiple copies of the template open (I work on multiple
projects frequently) I'd like to have that menu accessible to all of
the projects. Say for example that I close one of the spreadsheets.
The menu should still be available. Now I close that the last
spreadsheet that needs the menu, but I still have other generic
spreadsheets open. I would like the menu to dissappear or not appear
at all in the generic spreadsheets. Is this possible?

Thanks for any advice....AJ


--
AJ Master
------------------------------------------------------------------------
AJ Master's Profile: http://www.excelforum.com/member.php...o&userid=12386
View this thread: http://www.excelforum.com/showthread...hreadid=392638

Working with and adding Menus?
 

1. Create the menu when the workbook is opened and delete it as the workbook
is closed

2. As above but include code to check if there is an instance of your
custom menu already to prevent duplication and code to check if the menu is
still required because an example of your template is still open.

"AJ Master" wrote:


I have created a template and I have added a custom menu to perform some
common tasks.

1. Is there a way to make the menu only accessible to this spreadsheet
and not others that are open?

2. If I have multiple copies of the template open (I work on multiple
projects frequently) I'd like to have that menu accessible to all of
the projects. Say for example that I close one of the spreadsheets.
The menu should still be available. Now I close that the last
spreadsheet that needs the menu, but I still have other generic
spreadsheets open. I would like the menu to dissappear or not appear
at all in the generic spreadsheets. Is this possible?

Thanks for any advice....AJ


--
AJ Master
------------------------------------------------------------------------
AJ Master's Profile: http://www.excelforum.com/member.php...o&userid=12386
View this thread: http://www.excelforum.com/showthread...hreadid=392638