worksheet size limit

S

Sachin Narute

Hi all,
I want to use only 500 cells and A to N cells not ore than 500 cells.
i want to limit this no of cells.

Regards,
Sachin
 
D

dominicb

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
 
R

Roger Govier

Right click on the sheet tab of your workbook and choose View Code.
When the Visual Basic Editor window opens, look for the Sheet Properies
section (press F4 if it is not visible)
In Scroll Area, set the range to be $A$1:$N$500
Press the Xcel icon at top left of window to return to your sheet.

You will now be restricted to only entering data or scrolling within the
range A1 to N500
 
Top