Unwanted ToolBar from Downloaded File

  • Thread starter Thread starter Vic
  • Start date Start date
V

Vic

Please Help!
I downloaded an Excel workbook which had a custom
toolbar. Now whenever I open an Excel workbook (blank or
previously saved), the tool bar is visible and it's
accompanying VBA code can be viewed in the VBA Editor.
Unclicking this tool bar will shut it off for the
immediate session, but when the next excel file is
opened, THERE IT IS AGAIN! How do I get rid of it?
 
Open the VB Editor and look in This Workbook
for Application.Toolbars ("YourToolbar").Visible=True
Change the True to False
 
There are two common places that can be used to load files when xl starts.

One is under your XLStart folder. (Its location varies with versions of excel
and windows--but you can use Windows Start Button|Find to search for hidden
files (and through hidden folders).)

The other is as reference in Tools|Addins.

After you've removed the workbook from the XLStart folder (or removed the
refence in Tools|Addins, you may have to clean up that toolbar one more time.
 
Back
Top