LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 33
Default Showing worksheets in an Add-in

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Showing formula references in other worksheets Daz Excel Worksheet Functions 0 January 9th 09 06:00 AM
Combining two similar worksheets and showing changes dbsudy New Users to Excel 3 March 17th 06 10:35 PM
How do I move rows showing a specific field to other worksheets/. jmp Excel Discussion (Misc queries) 1 March 4th 05 05:42 AM
How do I move rows showing a specific field to other worksheets/. jmp Excel Discussion (Misc queries) 0 March 4th 05 04:27 AM
How do I move rows showing a specific field to other worksheets/. jmp Excel Discussion (Misc queries) 0 March 4th 05 04:27 AM


All times are GMT +1. The time now is 10:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"