Hidden macro

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

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
 
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.
 
Hi Don,
I have a workbook, which everytime it is opened creates a toolbar called
"leaders", even when the Disable Macros option is chosen.
Click to expand...

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
 
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.
 
Back
Top