Can I list my workbook sheets?

[Jenny]

I have an excell workbook in which there is a pricelist sheet for
ingredients and a (soon to be) large number of recipe sheets. Is it
possible for me to devise a list of recipe sheets from which I can
choose the recipe I wish to work on? Also, can I have the user use a
form for data entry, not the general one on the Data menu?
Thank you for your help.
Jenny

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[Frank Kabel]

Hi
for the second question see:
http://j-walk.com/ss/dataform/index.htm

 

[Dave Peterson]

And for question #1.

If each recipe is on a different worksheet, maybe you could use a "Table of
Contents" worksheet that contains hyperlinks to the individual sheets.

If you organize them nicely, it might work ok.

If you want to try it, David McRitchie has a macro that will build that table of
contents worksheet:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

If you're new to macros, you may want to read David's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Don Guillett]

After you use the other suggestions to make your list you might want to try
this to goto them.
right click sheet tab>view code>copy\paste this>double click on sheet name
to goto it.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Application.DisplayAlerts = False
Dim WantedSheet As String
WantedSheet = Trim(ActiveCell.Value)
If WantedSheet = "" Then Exit Sub
On Error Resume Next
If Sheets(ActiveCell.Value) Is Nothing Then
' GetWorkbook ' calls another macro to do that
Else
Sheets(ActiveCell.Value).Select
End If
Application.DisplayAlerts = True
End Sub