Hide vertical scroll bar from one sheet?

[niravrph]

Hi,

Can I hide the vertical scroll bar from just one Worksheet and not the others? If yes, can you tell me how to do it?

Thanks!
NIRAV

 

[Smitty]

You can use the Sheet Activate/Deactivate events to hide/show the scroll bar:

ActiveWindow.DisplayVerticalScrollBar = False

HTH,

 

[blbat]

There might be cleaner ways to do this...but it works for me:

Private Sub Worksheet_Activate()
ActiveWindow.DisplayVerticalScrollBar = False
End Sub

 

[blbat]

Heh! Sorry Smitty...you're quick on the trigger!

 

[niravrph]

Thank you guys (or gals). You and this board are the B-E-S-T!

NIRAV

 

[blbat]

also, you might want to set the value back to true on the Deactivate event of the sheet.