Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Jody,
Are you sure there isn't a hidden workbook being opened that might have this toolbar attached to it? Check the alternate startup file location. Any file that exists there will be opened automatically when Excel starts up. Toolbars can't appear out of thin air, so it's either being constructed in code or it's been prefabricated and attached to a workbook that's being opened. If you want to know the name of the procedure that a toolbar button is assigned to, choose View/Toolbars/Customize from the menu, then right-click over the toolbar button and select Assign Macro. The name of the Macro that appears in the Macro name box of the Assign Macros dialog is the one being run when that button is clicked. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "Jody" wrote in message ... Thanks to both of you for answering. There is definitely not an add-in for the toolbar. Also, as Rob mentioned, I checked in the Attach Toolbars dialog and the name of the toolbar does appear on the left hand side but it does not appear on the right hand side in that screen. The custom toolbar I am trying to modified is tied in with some VBA code we use. This code is loaded by setting the alternate start-up location. The systems administrator said that's all he has to do in order to set up a new computer, he does nothing specifically to load the toolbar. Now, I've done the obvious like to go through the code that the pull-down menus use and search for the name that Excel shows as the name of the toolbar. It doesn't find anything. If it isn't getting loaded here, I can't imagine where it is. I am so frustrated with this! Is there a command line statement I can use in the immediate window in order to see the function associated with a button? I think I've done all the obvious stuff like search for the name through the code that IS showing in the VBA editor and checking the Add-Ins. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I have more than 1 custom toolbar add-in in Excel 2007? | Excel Discussion (Misc queries) | |||
How do I set up a custom toolbar in Excel 2007? | Excel Discussion (Misc queries) | |||
What causes custom icons in the excel standard toolbar | Excel Discussion (Misc queries) | |||
excel should have a floating "custom view" toolbar | Excel Worksheet Functions | |||
saving toolbar buttons on custom toolbar | Excel Programming |