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: 397
Default Macro to go quickly to a sheet


Hi there,


I have about 40 sheets in a book. I need to quickly navigate to a sheet
by being able to enter the sheet name and then i want Excel to take me
to that sheet.
(i dont want to create a long list of hyperlinked names - would rather
run a macro that asks me what sheet I want to goto and takes me there...
or perhaps gotospecial command...?

Any ideas...

Many thanks

D


*** Sent via Developersdex http://www.developersdex.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
need to learn it all... quickly! ziploc_chik New Users to Excel 22 July 25th 08 05:37 PM
please help (need quickly) p-nut Excel Discussion (Misc queries) 4 December 29th 06 07:38 PM
need help quickly!! alexm999 Excel Discussion (Misc queries) 3 February 28th 06 02:42 PM
Need help, quickly please ame9 Setting up and Configuration of Excel 1 August 3rd 05 08:57 PM
How can I unmerge the merged cells in a Excel sheet quickly? Tomorrow Excel Programming 9 October 28th 04 05:00 PM


All times are GMT +1. The time now is 04:18 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"