Hide sheet - Help
 

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 ***

Hide sheet - Help
 

worksheets(4).visible = True


"Les Stout" wrote:

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 ***

Hide sheet - Help
 

Thanks Mike

Les Stout

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

Hide sheet - Help
 

Suggest using

= xlSheetVisible

instead of

= True

--
HTH

Bob

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

"Mike" wrote in message
...
worksheets(4).visible = True


"Les Stout" wrote:

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 ***

Hide sheet - Help
 

Will do thanks Bob...:-)

Les Stout

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