Limit cell range use

		Microsoft Office Forums > Microsoft Excel > Excel
Limit cell range use

12-29-2010, 11:16 PM

macropod

Windows 7 32bit Limit cell range use

Office 2000

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,525

Hi talkinglens,

You can limit the usable area with a macro like:

Code:

Sub Auto_Open()
ThisWorkbook.Sheets("Sheet1").ScrollArea = "A1:J10"
End Sub

in a general module, or:

Code:

Private Sub Workbook_Open()
ThisWorkbook.Sheets("Sheet1").ScrollArea = "A1:J10"
End Sub

in the workbook's 'ThisWorkbook' module.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
4K size limit, Outlook 2003 Task Export	sizzling4	Outlook	1	08-21-2010 04:52 PM
How to determine a user's mailbox size limit?	enviroko	Outlook	3	05-13-2010 07:02 AM
Moving formula range multiple cells when moving sum over one cell	FraserKitchell	Excel	4	02-26-2010 10:38 AM
Maximum limit on Inbox folders??	KarenK	Outlook	0	12-29-2009 10:38 PM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:20 AM.