Microsoft Office Forums - View Single Post - [Solved] Limit cell range use

Thread: [Solved] Limit cell range use

View Single Post

Old

12-29-2010, 11:16 PM

macropod

macropod is offline

macropod uses Windows 7 32bit

Windows 7 32bit macropod uses Office 2000

macropod uses Office 2000

Office 2000

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 21,963

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

Default

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]

Reply With Quote