Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toggle CommandBarControls msoButtonDown/msoButtonUp
Hi guys
I have some toolbar buttons whose state toggles between msoButtonUp and msoButtonDown depending on whether say, gridlines were displayed or not. I initialize these on Workbook_Open from PERSONAL.xls, and the code for each executes each time a button is clicked. This all works fine. What I can't work out, is if all workbooks are closed (and only PERSONAL.xls remains open), how can I get the buttons to toggle to a state I define (msoButtonUp)? None of the workbook events in PERSONAL.xls seem to trigger when the last visible workbook closes. Thanks in advance Paul Martin Melbourne, Australia |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toggle CommandBarControls msoButtonDown/msoButtonUp
Have you tried testing Workbooks.Count - it will be 1 if only Personal.xls
remains. -- HTH RP "Paul Martin" wrote in message om... Hi guys I have some toolbar buttons whose state toggles between msoButtonUp and msoButtonDown depending on whether say, gridlines were displayed or not. I initialize these on Workbook_Open from PERSONAL.xls, and the code for each executes each time a button is clicked. This all works fine. What I can't work out, is if all workbooks are closed (and only PERSONAL.xls remains open), how can I get the buttons to toggle to a state I define (msoButtonUp)? None of the workbook events in PERSONAL.xls seem to trigger when the last visible workbook closes. Thanks in advance Paul Martin Melbourne, Australia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run-time error commandbarcontrols | Excel Discussion (Misc queries) | |||
add of commandbarcontrols failed | Setting up and Configuration of Excel | |||
HELP - 'Add' of object 'CommandBarControls' failed | Excel Discussion (Misc queries) | |||
Method 'Add' of object 'CommandBarControls' failed | Excel Discussion (Misc queries) | |||
Problem getting a msoButtonDown status | Excel Programming |