Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hmm .... good question ... don't know!
I'm almost sure for a while all was working fine if I added the parameter Temporary:=True to commandbars.add(). But now that doesn't help. At the moment I can't say why it fails with no other visible workbooks, but the reason the OnTime fixes is because the close code is not being called from the button. (btw the issue is if there are/not other *visible* workbooks) Regards, Peter T "JeffTO" wrote in message ... Hi Peter Works perfectly - thank you soooo much And yes I do create the toolbar on open and delete on close The actual live code is more complex than the sample I gave but the problem was the same - so now that I have it working in the sample - I am going to implement in my live code Can you tell me why yours works and mine didnt? I am curious to know what the difference is. Thanks again - exteremely helpful Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
a command button problem | Excel Programming | |||
Command Button Problem | Excel Discussion (Misc queries) | |||
Closing an Excel Spreadsheet via command button | Excel Programming | |||
Problem with command button name | Excel Discussion (Misc queries) | |||
Command Button Problem | Excel Programming |