Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all
I've the following problem deleting a commandbutton in the toolbar: 1. A customized commandbar button is created to invoke a userform 2. Within the userform the user has the option to change the commandbarbutton 3. To replace the button the procedure first tries to delete the button and afterwards to add a new button (with the new layout). For deleting the following statement is used: Application.CommandBars("Standard").Controls ("Button_Title").Delete This returns an automation error if invoked from the userform. No problem if invoked directly (e.g. from the immediate window). Problem seems to be that the commandbarbutton is still 'pressed down' due to invoking the userform in the first place and can therefore not be deleted. Does anybody has an idea how to solve thisand how to delete the button (even resetting the button does not help. Only resetting the complete commandbar would do but this also remove all other customised settings of this bar) Frank |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting a Command Button | Excel Discussion (Misc queries) | |||
Deleting a Command Button from my Spreadsheet | Excel Discussion (Misc queries) | |||
Command Button run-time error | Excel Programming | |||
Deleting some cells in a row using command button and offset | Excel Programming | |||
Run-time error on command button | Excel Programming |