Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / March 2008

Tip: Looking for answers? Try searching our database.

Add-in is visible

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DZ - 06 Mar 2008 02:51 GMT
I created an addin for Excel (.XLA). It works fine but sometimes when it is
added to the current workbook it is visible

How can I make sure that it always opens invisibly when it is loaded?

Thanks for any help
Peter T - 06 Mar 2008 09:07 GMT
If the file is truly an Addin it will not be visible. Sounds like the file
is a normal file that happens have an xla extension.

In the VBE, in the Project panel (if necessary Ctrl-R), select the
ThisWorkbook module in your project. In the Properties panel (if necessary
F4) Ensure  IsAddin is True. Close all module windows and collapse the tree
in the Project panel.

Save the file with the icon in the VBE menu, or with the project name still
highlit, in the Immediate window (Ctrl-G) type
thisworkbook.save
and hit enter

Actually before doing the above, you say sometimes the addin is hidden but
other times not, I wonder if you have two similarly named files in different
locations, one truly an addin but the other not. Might be worth searching
your HD for duplicates. Rename the non-addin as .xls

Regards,
Peter T

> I created an addin for Excel (.XLA). It works fine but sometimes when it is
> added to the current workbook it is visible
>
> How can I make sure that it always opens invisibly when it is loaded?
>
> Thanks for any help
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.