LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting Headers and Footers that are in the drop down Menu? Lisa Excel Discussion (Misc queries) 1 March 5th 07 06:33 PM
Deleting items as they are used from a drop down menu ToferKing Excel Programming 4 April 19th 06 11:01 PM
Deleting menu (xla) ravi Excel Programming 2 August 10th 05 09:00 PM
Deleting Menu ravi Excel Programming 2 August 4th 05 03:59 PM
Deleting a Menu Bar Sophie Excel Programming 5 July 18th 04 08:29 PM


All times are GMT +1. The time now is 07:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"