Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden macro
I have a workbook, which everytime it is opened creates a toolbar called
"leaders", even when the Disable Macros option is chosen. I would like to be able to unhide and customize this macro if possible. I have tried deleting all the Modules, perusing thru all worksheets for code, etc. but still the toolbar appears. I am using Office XP, any help would be appreciated, TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden macro
Was the workbook created in xl5 or xl95. If so, the menu is created using
the menu editor and this is how the menu is created. It isn't done with code. Another possibility is that the workbook was created in xl97 or later and the menu attached to the workbook. You can go to Tools=Customize and on the first tab, select the Attach button and remove the attached commandbar. -- Regards, Tom Ogilvy "Don" wrote in message ... I have a workbook, which everytime it is opened creates a toolbar called "leaders", even when the Disable Macros option is chosen. I would like to be able to unhide and customize this macro if possible. I have tried deleting all the Modules, perusing thru all worksheets for code, etc. but still the toolbar appears. I am using Office XP, any help would be appreciated, TIA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden macro
Hi Don,
I have a workbook, which everytime it is opened creates a toolbar called "leaders", even when the Disable Macros option is chosen. No macro, but an attached toolbar. Open the workbook Rightclick your commandbar, select customise Click the toolbars tab en click Attach Select the toolbar(s) on the righthand side and click delete. Save the workbook. Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden macro
Thanks Tom, it was attached to the Standard toolbar. Never came across it
before, even so I still feel foolish for missing something so obvious. "Tom Ogilvy" wrote in message ... Was the workbook created in xl5 or xl95. If so, the menu is created using the menu editor and this is how the menu is created. It isn't done with code. Another possibility is that the workbook was created in xl97 or later and the menu attached to the workbook. You can go to Tools=Customize and on the first tab, select the Attach button and remove the attached commandbar. -- Regards, Tom Ogilvy "Don" wrote in message ... I have a workbook, which everytime it is opened creates a toolbar called "leaders", even when the Disable Macros option is chosen. I would like to be able to unhide and customize this macro if possible. I have tried deleting all the Modules, perusing thru all worksheets for code, etc. but still the toolbar appears. I am using Office XP, any help would be appreciated, TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hidden Macro | Excel Discussion (Misc queries) | |||
hidden macro? | Excel Discussion (Misc queries) | |||
Hidden Macro | Excel Discussion (Misc queries) | |||
macro to hidden worksheet | Excel Discussion (Misc queries) | |||
Macro and hidden sheets | Excel Discussion (Misc queries) |