That code must be put into the ThisWorkbook Code Module. The easiest way to
get there is from XL right click on the XL Icon in the upper left corner of
the window. Select View Code. This will open the VBA screen and take you
directly into the ThisWorkbook module. Past the code there. If that code is
pasted into a regular module it will not be executed so it will not do much...

As for the sheet the sheet is defined right in the code
Sheets("HerdDescription").
so it will operate on that sheet.
--
HTH...

Jim Thomlinson


"Brenda" wrote:

I want to set up this code:
Private Sub Workbook_Open()
Sheets("HerdDescription").ScrollArea = "N1:N25"
End Sub

However i am not sure how about applying it to the correct sheet. I have
hidden the rows and columns however i can still scroll and i don't want to do
that. I have been ready others replies but i am lost on the applying part.
Can someone help me.
--
Thank you, Brenda