View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones[_2_] Norman Jones[_2_] is offline
external usenet poster
 
Posts: 421
Default Display Worksheets from AddIn


Hi Groupie,

An add-in's worksheets are hidden.

To unhide the sheets, you would have to
change the add-in's IsAddin poperty to
False. either manually( in the Explorer window
of the VBE : select the ThisWorkbook
module and hit F4 to open the properties
window) or by code.

However, this causes the addin to revert
to a standard workbook, which Isuspect
is not what you want.


Perhaps, explain in a little more detail what
you are endeavouring to achieve, and you
will find many here ready to help,



---
Regards.
Norman

"groupie" wrote in message
...
Hi,
How are the Worksheets displayed from an AddIn? When AddIn in added,
I've created a custom menu which when selected calls a Subroutine in
the file which assumes that the Worksheets are open but it's not and
I'm getting errors...thanks.