Thread: Deleting menu
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
martijn600 martijn600 is offline
external usenet poster
 
Posts: 1
Default Deleting menu

Hello,

At the moment I am dealing with the following problem:
A template file contains a menu.
This template file may be opened multiple times, it is checked for the name
in the toolbar to prevent adding the menu multiple times.

Now my question is:
How can I make sure that at closing the files, the menu is only deleted when
no file is open anymore that uses the template?

I have tried this by counting in the un-used member Parameter of
Application.Toolbar(<name menu) the number of time the template has been
opened but this doesn't work because at opening the file when the value
should be incremented, an empty string is returned.

Hope to get some help soon,
Martijn