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

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
>
>

If you are looking to have it available for only one sheet in the
workbook...

use the worksheet_activate and worksheet_deactivate events.

--
steveB

Remove "AYN" from email to respond
"bigwheel" <bigwheel@discussions.microsoft.com> wrote in message
news:128F0DC0-87DD-49DB-A2F0-1A2135C5715D@microsoft.com...
> 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
>>
>>