Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
animated text in excel worksheet
 
Posts: n/a
Default make an excel worksheet (sheet 2) open w/ the cursor located in t.

I have an excel worksheet with three sheets. Sheets 2 and 3 are locked so
that entries can be made in only certain cells. Sheet 3 is linked to sheet 2
so that when an entry is made on sheet 2, the entry appears on sheet 3 in the
corresponding cell.

I would like sheet 3 to open in the cell the last entry was made (which is
the corresponding cell on sheet 2 because sheet 3 is completly locked except
for the link to sheet 2)

Is there a simple way to perform this task?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open existing Excel file Bill Coupe Excel Discussion (Misc queries) 3 January 18th 05 08:53 PM
unable to open Excel file by double clicks Renyan Excel Discussion (Misc queries) 2 January 16th 05 02:07 AM
Need to remove a password that noone placed on Excel worksheet. tuffy1104 Excel Worksheet Functions 2 January 2nd 05 08:12 PM
Is there a way to make Excel 2000 open a new worksheet in a new w. gdub Excel Discussion (Misc queries) 1 December 22nd 04 04:56 PM
Hyperlink to specific sheet in Excel Web File jd17 Links and Linking in Excel 0 December 8th 04 10:03 PM


All times are GMT +1. The time now is 01:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"