ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel 2007 - worksheets macro (https://www.excelbanter.com/excel-worksheet-functions/259026-excel-2007-worksheets-macro.html)

version83

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.

Gord Dibben

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.




All times are GMT +1. The time now is 10:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com