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

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

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

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