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

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

I still must be doing something wrong. I followed your instructions however,
nothing has happened do i need to save exit and then go back in to make it
work? Sorry to be so dumb on this i am very new at doing this.
--
Thank you, Brenda


"Jim Thomlinson" wrote:

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

That will do it. The other option is just to go the the VBE and put your
cursor in the procedure somewhere and hit F5 to execute the code.
--
HTH...

Jim Thomlinson


"Brenda" wrote:

I still must be doing something wrong. I followed your instructions however,
nothing has happened do i need to save exit and then go back in to make it
work? Sorry to be so dumb on this i am very new at doing this.
--
Thank you, Brenda


"Jim Thomlinson" wrote:

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

Finally got it to work but how come i can use my wheel on the mouse and still
scroll down. When i use the arrows on my keyboard it works like it is suppose
to.
--
Thank you, Brenda


"Jim Thomlinson" wrote:

That will do it. The other option is just to go the the VBE and put your
cursor in the procedure somewhere and hit F5 to execute the code.
--
HTH...

Jim Thomlinson


"Brenda" wrote:

I still must be doing something wrong. I followed your instructions however,
nothing has happened do i need to save exit and then go back in to make it
work? Sorry to be so dumb on this i am very new at doing this.
--
Thank you, Brenda


"Jim Thomlinson" wrote:

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