ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to hide or minimize add-in (https://www.excelbanter.com/excel-programming/377850-how-hide-minimize-add.html)

Tony Logan

how to hide or minimize add-in
 
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.

Peter T

how to hide or minimize add-in
 
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

"Tony Logan" wrote in message
...
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.




Tony Logan

how to hide or minimize add-in
 
That was it. Thanks so much!

"Peter T" wrote:

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

"Tony Logan" wrote in message
...
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.






All times are GMT +1. The time now is 02:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com