hi
as a suggestion, you might try the worksheet activation event....

Private Sub Worksheet_Activate()
Range("G5").Select 'adjust to suit
MsgBox "SCROLL RIGHT & USE APPROPRIATE INPUT AREA"
'MsgBox "Start input at G5" 'as an alternative instruction.
End Sub

this is worksheet code so right click the sheet tab, click "view code" and
paste there.

regards
FSt1

"Jack Wood" wrote:


Now for the next problem. In one of my worksheets a have typed in it
"SCROLL RIGHT & USE APPROPRIATE INPUT AREA". I have hyperlinked so when
you click on "SCROLL RIGHT & USE APPROPRIATE INPUT AREA" it
automatically scrolls right to the specified cell # so you can start
your input. This will not work in a copy of the original file. How can
I get it to scroll right automatically without it going back to the
original file.


--
Jack Wood
------------------------------------------------------------------------
Jack Wood's Profile: http://www.thecodecage.com/forumz/member.php?userid=346
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=101372