Good morning Sachin Narute
You have two options:
(1) Hide columns O to IV and rows 500 to 65,536. This will give the
appearance of a spreadsheet set on a 14 x 500 grid.
(2) Use the ScrollArea command thus:
Worksheets(1).ScrollArea = "A1:N500"
Once run this macro will display the whole sheet but restict the users
movements to your prescribed range. This would not be saved with the
workbook, but you could run this from your Workbook_Open event so that
it is run when the file is opened.
HTH
DominicB
--
dominicb
------------------------------------------------------------------------
dominicb's Profile:
http://www.excelforum.com/member.php...o&userid=18932
View this thread:
http://www.excelforum.com/showthread...hreadid=392087