LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default command button to move user to specific spot on different sheet


First sheet on my worksheet contains a protected instruction page.
Have a "help" commandbutton at the bottom of each subsequent page.

I would like, when the commandbutton is pressed, to take the user to
the specific portion of the instruction page. Basically:

when the help button is pressed on sheet 2, it takes the user to sheet
1 with row 15 at "the top"
when the help button is pressed on sheet 3, it takes the user to sheet
1 with row 37 at "the top"
when the help button is pressed on sheet 4, it takes the user to sheet
1 with row 59 at "the top"
and so on...

sheet 1 is protected, so i cannot (or can i?) select specific cells...

any help is much appreciated


--
grime
------------------------------------------------------------------------
grime's Profile: http://www.excelforum.com/member.php...o&userid=19227
View this thread: http://www.excelforum.com/showthread...hreadid=501072

 
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
Move and reset valuse using a command Button Chris Excel Discussion (Misc queries) 0 December 29th 09 11:54 PM
command button to move data dummy Excel Worksheet Functions 3 December 5th 09 06:44 PM
Creating a "Next" button to move the user to the next sheet Rob Excel Discussion (Misc queries) 2 March 29th 09 12:14 PM
command button move worksheet from one workbook to another Qaspec Excel Programming 3 February 2nd 05 12:55 PM
command button in excel will move when print. [email protected] Excel Discussion (Misc queries) 1 December 29th 04 03:53 PM


All times are GMT +1. The time now is 08:40 AM.

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

About Us

"It's about Microsoft Excel"