Showing worksheets in an Add-in

  • Thread starter Thread starter Shatin
  • Start date Start date
S

Shatin

Hi all,

There's a workbook which I use frequently. There are a few worksheets in the
workbook that I'd like to prefer to from time to time. I have written macros
to hide and unhide these sheets. I've also created menu bar controls for the
workbook. Since I use this workbook so frequently, I want to save it as an
add-in. The problem is once saved as an add-in, those worksheets that I'd
like to refer will remain hidden. Is there anyway to show worksheets of an
add-in?
 
Not without copying them to another workbook. If your objective is to just
have the workbook always open, put it in your xlstart directory.
 
Shatin;

This is what Excel Help tells you about the Addin.
The answer is NO. (See second dot)
IsAddin Property
Remarks
When you set this property to True, the workbook has the following
characteristics:

a.. You won't be prompted to save the workbook if changes are made while
the workbook is open.
b.. The workbook window won't be visible.
c.. Any macros in the workbook won't be visible in the Macro dialog box
(displayed by pointing to Macro on the Tools menu and clicking Macros).
d.. Macros in the workbook can still be run from the Macro dialog box even
though they're not visible. In addition, macro names don't need to be
qualified with the workbook name.
e.. Holding down the SHIFT key when you open the workbook has no effect.
Mark.

More Excel ? www.rosenkrantz.nl or (e-mail address removed)
 
Back
Top