opposite of XLVeryhidden!!
 

Hi members,
Please let me know if anybody knew the opposite of xlVeryHidden.
I have made a sheet hidden using the below code.

Sheets("sheet1").Visible = xlVeryHidden


Now if want to make it visible, what is the macro to write.

Please advice..

Thanks

:confused: Roshi

--
roshinpp_7
-----------------------------------------------------------------------
roshinpp_77's Profile: http://www.excelforum.com/member.php...fo&userid=3492
View this thread: http://www.excelforum.com/showthread.php?threadid=54853

opposite of XLVeryhidden!!
 

Have you tried

Sheets("sheet1").Visible = True

Duncan

opposite of XLVeryhidden!!
 

Sheets("sheet1").Visible = xlsheetvisible

or

Sheets("sheet1").Visible = True
try those...

roshinpp_77 Wrote:
Hi members,
Please let me know if anybody knew the opposite of xlVeryHidden.
I have made a sheet hidden using the below code.

Sheets("sheet1").Visible = xlVeryHidden


Now if want to make it visible, what is the macro to write.

Please advice..

Thanks

:confused: Roshi

--
pianoma
-----------------------------------------------------------------------
pianoman's Profile: http://www.excelforum.com/member.php...fo&userid=3371
View this thread: http://www.excelforum.com/showthread.php?threadid=54853

opposite of XLVeryhidden!!
 

Sheets("sheet1").Visible = xlsheetvisible

or

Sheets("sheet1").Visible = True
try those...

roshinpp_77 Wrote:
Hi members,
Please let me know if anybody knew the opposite of xlVeryHidden.
I have made a sheet hidden using the below code.

Sheets("sheet1").Visible = xlVeryHidden


Now if want to make it visible, what is the macro to write.

Please advice..

Thanks

:confused: Roshi

--
pianoma
-----------------------------------------------------------------------
pianoman's Profile: http://www.excelforum.com/member.php...fo&userid=3371
View this thread: http://www.excelforum.com/showthread.php?threadid=54853

opposite of XLVeryhidden!!
 

Thanks Duncan...it was as so simple...




Duncan Wrote:
Have you tried

Sheets("sheet1").Visible = True

Dunca

--
roshinpp_7
-----------------------------------------------------------------------
roshinpp_77's Profile: http://www.excelforum.com/member.php...fo&userid=3492
View this thread: http://www.excelforum.com/showthread.php?threadid=54853