Limit workbook size

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

R D S - 14 May 2005 19:23 GMT

Hi,
Can someone please remind me how to limit the size of a sheet?
I dont need anything past V:30

Thanks,
Rick

Reply to this Message

Dave Peterson - 14 May 2005 19:40 GMT

Maybe just hiding columns W:IV and rows 31:65536.

They're always going to exist, though.

> Hi,
> Can someone please remind me how to limit the size of a sheet?
> I dont need anything past V:30
>
> Thanks,
> Rick

Signature

Dave Peterson

Reply to this Message

William - 14 May 2005 20:10 GMT

Hi

Try entering this code in the "ThisWorkbook" module.

Private Sub Workbook_Open()
With Sheets("Sheet1")
.scrollarea = ""
.scrollarea = "A1:V30"
End With
End Sub

Signature

XL2003
Regards

William
willwest22@yahoo.com

> Hi,
> Can someone please remind me how to limit the size of a sheet?
> I dont need anything past V:30
>
> Thanks,
> Rick

Reply to this Message