Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default 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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I minimize chrisnsmith Excel Discussion (Misc queries) 8 March 3rd 09 03:56 AM
Minimize?? Doug Mc New Users to Excel 3 January 30th 06 09:03 PM
how do i minimize/maximize a workbook from vba? I want to minimize it durring processing to speed things up a bit Daniel Excel Worksheet Functions 2 July 9th 05 03:35 AM
minimize problem dave Excel Worksheet Functions 0 June 7th 05 03:14 PM
How to minimize a form using VB Jean Oct Excel Programming 2 July 28th 03 08:00 PM


All times are GMT +1. The time now is 09:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"