Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unhide sheet based on NamedRange?
Hi All,
Is there a way to unhide a hidden sheet based on the the named range. For example if you want to select a named range say 'MyRange' whose address is Sheet1!A1:A20 but Sheet1 is hidden is there a simple way to extract the Sheet name. TIA Regards Michael Beckinsale |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unhide sheet based on NamedRange?
Dim sh as Worksheet
set sh = Range("MyRange").Parent sh.Visible = xlSheetVisible -- Regards, Tom Ogilvy "Michael Beckinsale" wrote: Hi All, Is there a way to unhide a hidden sheet based on the the named range. For example if you want to select a named range say 'MyRange' whose address is Sheet1!A1:A20 but Sheet1 is hidden is there a simple way to extract the Sheet name. TIA Regards Michael Beckinsale |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unhide sheet based on NamedRange?
Tom,
Many thanks for the prompt reply. Perfect. Just what l want! Regards "Tom Ogilvy" wrote in message ... Dim sh as Worksheet set sh = Range("MyRange").Parent sh.Visible = xlSheetVisible -- Regards, Tom Ogilvy "Michael Beckinsale" wrote: Hi All, Is there a way to unhide a hidden sheet based on the the named range. For example if you want to select a named range say 'MyRange' whose address is Sheet1!A1:A20 but Sheet1 is hidden is there a simple way to extract the Sheet name. TIA Regards Michael Beckinsale |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I unhide/hide a sheet based on pull down selection? | Excel Discussion (Misc queries) | |||
HELP!! Unhide Sheet with Macro and focus on other sheet | Excel Discussion (Misc queries) | |||
Hide/unhide sheet macro based on cell calculation | Excel Programming | |||
Unhide sheets based on NT login | Excel Programming | |||
Unhide sheets based on a cell value | Excel Programming |