Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Default Excel 2007 - worksheets macro

Hello.
I am using excel 2007, and i am still a beginner, so i would like to ask for your help for making the following:

a macro which adds a list with the available worksheets in the current workbook, within the context menu.
The selected sheet from the context menu, must become active.

Thank you.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Excel 2007 - worksheets macro

How about a sheet navigation toolbar from Dave Peterson?

http://www.contextures.on.ca/xlToolbar01.html

Or Bob Phillips' Browsesheets macro which I like best, but that's me<g

See this google search result. All one line for the URL

http://groups.google.com/group/micro...c19464f875bd25



Gord Dibben MS Excel MVP


On Tue, 16 Mar 2010 15:59:01 +0000, version83
wrote:


Hello.
I am using excel 2007, and i am still a beginner, so i would like to
ask for your help for making the following:

a macro which adds a list with the available worksheets in the current
workbook, within the context menu.
The selected sheet from the context menu, must become active.

Thank you.


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
Comparing 2 worksheets in Excel 2007 Sue Excel Worksheet Functions 1 November 30th 09 07:13 PM
Excel 2007 worksheets Help sorely needed Excel Discussion (Misc queries) 2 April 5th 09 09:22 PM
Excel 2007 Macro Help (Excel 2003 not working in 2007) Pman Excel Discussion (Misc queries) 4 May 29th 08 06:29 PM
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort Gavin Excel Worksheet Functions 0 May 17th 07 01:20 PM
Excel 2007 - Hidden worksheets pskwaak Excel Worksheet Functions 2 March 11th 07 12:06 PM


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