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