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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top