Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to check if workbook is the last one opened
Hi
I need to run code from a command button that closes the Activeworkbook. This code runs from an addin file. I would like the code to check and see if the activeworkbook is the last workbook open and if it is then code "a" will run and if not then code "b" will run. I'm not sure how to check to see if the active workbook is the last workbook open. Any help would be greatly appreciated. Thanks in advance, Kimberly |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to check if workbook is the last one opened
Kimberly,
Try workbooks.Count but be aware that there may be some hidden workbooks opened, such as Personal.xls. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "KimberlyC" wrote in message ... Hi I need to run code from a command button that closes the Activeworkbook. This code runs from an addin file. I would like the code to check and see if the activeworkbook is the last workbook open and if it is then code "a" will run and if not then code "b" will run. I'm not sure how to check to see if the active workbook is the last workbook open. Any help would be greatly appreciated. Thanks in advance, Kimberly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check a sheet each time file opened? | Excel Discussion (Misc queries) | |||
Formating Cells used code when worksheet opened | Excel Worksheet Functions | |||
How do I check opened wokbooks? | Excel Programming | |||
Is it possible to require that a KEY NUMBER be imputed in a workbook 1 before workbook 2 can be opened? | Excel Programming | |||
Code to tell if workbook is opened in browser | Excel Programming |