Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have two questions that hopefully someone might have answers to. First, i have created a plug in for excel that i use only when a specific file is opened. The plug in also creates a toolbar to run this code. Is it possible to only show the toolbar when that specific file is opened? I tried to do it from "This workbook" in workbook_open sub, but it just doesn't show the toolbar at all. I test for opened file, but for some reason it always shows that the file isn't opened. Second, when i click Exit on my userform after running the code, it closes this workbook that i'm working with. That's fine when there's more than one excel file open, but if this file is the only one that's open, i'd like to use something like Application.Quit to close the application. How can i check to see if there is more than one excel file open? Thanks for all your help. IB |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to check for Open File! | Excel Discussion (Misc queries) | |||
check if file is already open | Excel Discussion (Misc queries) | |||
check if a file is open | Excel Programming | |||
execl to check if another excel file is open... | Excel Programming | |||
How to check Excel file already Open | Excel Programming |