how to code

I want to "Limit the scrolling" on multiple work sheets in one work book to present only the forms I've developed.

Gord Dibben had the answer to code the work book in another thread for a single worksheet.

Private Sub Work Book_ Open()
sheets("Your sheet").ScrollArea = "A1:F17"
End Sub

That worked Great! But now I want to do multile forms within the work book and I can't make it happen, Any Ideas?

Until someone comes up with a coding solution, you could try hiding unwanted columns and rows. First link all the sheets together in the workbook by holding down the control key and clicking on each sheet's tab - all tabs should turn white. Highlight all the columns to the right of the range of columns to remain, and hide them. Then highlight all the rows below the range of rows to remain and hide those too. Save the workbook. When reopened, all sheets should only show the range of cells you wanted to use, and the scrolling is limited on all the sheets too.