Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-in is visible
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-in is visible
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 "DZ" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofilter: jump from visible row to visible row by command button | Excel Programming | |||
Worksheet has to set to visible as it is not visible after saving and closing Excel by VB. | Excel Programming | |||
Autoshapes not visible on spreadsheet but visible in print preview | Excel Discussion (Misc queries) | |||
Toggle text to be visible and not visible | Excel Programming | |||
Toggle Text in a column to be visible or not visible | Excel Programming |