Hide sheet - Help

[Les Stout]

Hi all, i have used the following to hide a sheet and need to make it
visable again, could somebody help me out with some code ?

worksheets(4).visible = xlSheetVeryHidden


Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

 

[Mike]

worksheets(4).visible = True

 

[Les Stout]

Thanks Mike

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

 

[Bob Phillips]

Suggest using

= xlSheetVisible

instead of

= True

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Les Stout]

Will do thanks Bob...

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***