View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Locking the view of Excel sheet

Hi
manualyy: Goto 'Tools - Options - View' and uncheck both
scrollbars.
If you need a macro record the above action and use the
recorded code
-----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/





.