Prev: Using spreadsheet to fill in forms
Next: Help with SumProduct
From: version83 on 16 Mar 2010 11:59

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.




--
version83
From: Gord Dibben on 16 Mar 2010 16:56
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/microsoft.public.excel.worksheet.functions/browse_frm/thread/935f5e174087f636/02c19464f875bd25?lnk=st&q=&rnum=1#02c19464f875bd25



Gord Dibben MS Excel MVP


On Tue, 16 Mar 2010 15:59:01 +0000, version83
<version83.5e595d6(a)excelbanter.com> 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.

 | 
Pages: 1
Prev: Using spreadsheet to fill in forms
Next: Help with SumProduct