What's the VB code for restricting the rows and columns on a worksheet
N Nick Hodge Sep 23, 2004 #3 K483 Try something like Sub RestrictMovement() Worksheets("Sheet1").ScrollArea = "$A$1:$Z$50" End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England [email protected]
K483 Try something like Sub RestrictMovement() Worksheets("Sheet1").ScrollArea = "$A$1:$Z$50" End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England [email protected]