Want to hide the scroll bars( both horizontal and vertical) in one worksheet

Hi,

I am working on a macro which consists of so many sheets in one workbook. I want to lock the scroll bars in one of the sheets so that the content wont move off the screen. The other sheets should have the scroll bars..

Please help me out

Thanks in Advance

Thanks for your reply,

This VBA code solved the problem to some extent, but If I close and reopen the Excel the scrolling in that sheet is again getting activated.

Please help me resolve this....

Originally Posted by patel45

Please Login or Register  to view this content.

put this macro not in a module but in thisworkbook section

Originally Posted by ananthbulusu

Thanks for your reply,

This VBA code solved the problem to some extent, but If I close and reopen the Excel the scrolling in that sheet is again getting activated.

Please help me resolve this....

Got the solution for this..Just I pasted the below code in the This workbbok in the VBA code..That way this will get executed at the opening time of the excel.
TADA...problem solved...

[ B]Private Sub Workbook_Open()

Sheet8.ScrollArea = "A1:R17"

End Sub
[/B]

Thank you all