Frank Kabel wrote:
Hi
manualyy: Goto 'Tools - Options - View' and uncheck both
scrollbars.
If you need a macro record the above action and use the
recorded code
Hi .. The following is the recording ..
Sub Macro1()
'
With ActiveWindow
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
End With
End Sub
This hides the scroll bars for all the sheets ..i want to hide it on the
1st sheet, but show it on all others...
any way to do this ... ?
Thanks
Abhinav
-----Original Message-----
Hi,
Is there any way to hide the scroll bars also .. ?
Thanks
Abhinav
Harald Staff wrote:
Hi Sameer
Assuming you want a programming solution:
Sub Makro1()
Rows("55:65536").Hidden = True
Columns("P:IV").Hidden = True
End Sub
HTH. Best wishes Harald
"sameerce "
skrev i melding
...
Hi,
I wanted to lock the view of Excel sheet so that only
certain number of
rows and columns are displayed to the user. Since I
have an Excel sheet
where in only 50 rows are to be displayed and data has
to be entered in
these cells. There is no need for showing the rest of
the cells. The
user should not be able to scroll horizontally or
vertically beyond
this number of cells.
Can this be acheived by some means.
Thanks,
Sameer
---
Message posted from http://www.ExcelForum.com/
.