Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 -------------------------------------------------------------------- "Shatin" wrote in message ... 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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Showing formula references in other worksheets | Excel Worksheet Functions | |||
Combining two similar worksheets and showing changes | New Users to Excel | |||
How do I move rows showing a specific field to other worksheets/. | Excel Discussion (Misc queries) | |||
How do I move rows showing a specific field to other worksheets/. | Excel Discussion (Misc queries) | |||
How do I move rows showing a specific field to other worksheets/. | Excel Discussion (Misc queries) |