Home |
Search |
Today's Posts |
#1
|
|||
|
|||
worksheet size limit
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 -- Regards Roger Govier "Sachin Narute" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
How do I reduce the worksheet size ? | Excel Discussion (Misc queries) | |||
Trying to enlarge tab size on worksheet for easier reading | Excel Discussion (Misc queries) | |||
Can I split my worksheet and have different size columns and rows. | Excel Discussion (Misc queries) | |||
Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions |