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 Macro to move between sheets

Hi,

I would like to have a macro that would look at a value in cell A5 and
then go to the Worksheet that has the same name.

For example if i typed Sheet 1 in cell A1 then clicked on the macro i
would automatically be taken to Sheet 1.

Is this possible?

Regards

Pete


---
Message posted from http://www.ExcelForum.com/

 
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 between sheets in workbook tiitsius Setting up and Configuration of Excel 1 April 28th 10 10:55 AM
VBA to Move Sheets and save jlclyde Excel Discussion (Misc queries) 3 February 24th 09 12:58 PM
how do I move between sheets in a workbook using the keyboard.... hamiltoncruiser Excel Discussion (Misc queries) 2 December 12th 07 03:46 AM
Cannot Move or Copy Sheets Toys Excel Discussion (Misc queries) 1 June 20th 07 12:59 PM
Use Tab key to move between tab sheets Lisa Excel Worksheet Functions 0 January 5th 06 04:06 PM


All times are GMT +1. The time now is 02:51 PM.

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"