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.
|