Fixing the number of Coloms and rows.

H

HUNTER

How can I Fix the Rows (suppose I want only 30 row in my worksheet) number so
that no one (without a password) can change the length of rows...
 
M

Max

Below is one response to your multi-post in .worksheet.functions
(Please do not multi-post)

----
One play to restrict the scrolling area..

In a new book, try the sub below,
which is to be placed in the "ThisWorkbook" module

Right-click on the Excel icon just to the left
of "File" on the menu > Choose "View Code"
(This will bring you direct into the "ThisWorkbook" module)

Copy > Paste the sub below into the code window on the right

'--------
Private Sub Workbook_Open()
Worksheets("Sheet1").ScrollArea = "A1:B10"
End Sub
'--------

Save the book, then re-open it, and test it out.
The scroll area in Sheet1 will be restricted to the range as defined,
viz.: A1:B10

Adapt to suit ..
 
N

Nick Hodge

Hunter

You could set the scrollarea in a workbook_open event like

Private Sub Workbook_Open()
Sheet1.ScrollArea = "$A$1:$Z$50"
End Sub

This goes in the ThisWorkbook module

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
www.nickhodge.co.uk
 
Top