| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Evaluate Open Files / multiple instances open
I have a custom menu bar that gets activated when the file is open and gets
reset when the file is closed. Problem is the user is now telling me they may have multiple instances of the same file open at one time. I altered the Add code to reset before adding, so that only one set of the menubar was open. This seems to work fine, problem is on the close event I need to evaluate if multiple sheets (of this type) are open and then skip the Reset (Application.CommandBars(1).Reset) on the close, if it is not the last sheet of this kind open. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open Excel 2007 files in new instances | Setting up and Configuration of Excel | |||
| Repost: open multiple instances of Excel | Excel Discussion (Misc queries) | |||
| Excel opens new instances when I text-open files | Excel Discussion (Misc queries) | |||
| to open multiple instances of excel | Excel Discussion (Misc queries) | |||
| open multiple files | Excel Discussion (Misc queries) | |||
Threaded Mode
