how to hide or minimize add-in

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an add-in that runs when a user either first starts Excel or opens a
worksheet. The add-in checks any opened worksheet for several things (fonts,
tagged data, etc.).

The add-in is in the XLStart folder (running Windows XP, SP2, so the path to
the add in is C:\Program Files\Microsoft Office\OFFICE11\XLSTART).

When I open Excel, the add-in is visible and appears like any other
worksheet (except that it's named with an xla extension). The add-in is set
as read-only, so there's no real danger that users can change it, but I'd
like to know if there's a way to either keep the add-in from appearing
(best-case scenario), or failing that, at least minimize the add-in.

Thank you.
 
Are you sure it's really an addin? It should have been saved as an addin,
not simply the extension renamed.
Select the file in project explorer and change the IsAddin property to True.
Save from the VBE.

Regards,
Peter T
 
That was it. Thanks so much!

Peter T said:
Are you sure it's really an addin? It should have been saved as an addin,
not simply the extension renamed.
Select the file in project explorer and change the IsAddin property to True.
Save from the VBE.

Regards,
Peter T
Click to expand...
 

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

Similar Threads

How to call module function or sub from the Add In? 3
How to change add-in object from within worksheet module. 3
Best practise XLA add-in 3
Excel 2013 menubar incompatibility? 1
xlstart .xla automatically opens when starting Excel 2003 1
How to start the Macro when I open Excel 2
How to start a Macro when I open Excel 1
add-in, data in Add-in file (woorksheet) 2

Back
Top