VBA Code for Selecting sheets

[Speed boy]

Please help...
Have a workbook w/ 32 sheets. Would like a drop down box on page 1 that lets you choose which sheet you want vs. scrolling through all those tabs. And ideas?

[nisht]

Friend,
Download file nos 8

http://www.pexcel.com/download.htm

name of the file is 'Sheet Names'

i think this can help you..


other way to go around is:
right click on the sheet navigation button and you will get the names of all the sheet.

nishith desai
http://www.pexcel.com

[ This Message was edited by: nisht on 2002-04-03 05:54 ]

[Speed boy]

Thanks, however the utility will not be on the users computer. I was hoping for VBA code so the sheet selection module would be included in the end users workbook.

Thanks for the reply.

SB
On 2002-04-03 05:53, nisht wrote:
Friend,
Download file nos 8

http://www.pexcel.com/download.htm

name of the file is 'Sheet Names'

i think this can help you..


other way to go around is:
right click on the sheet navigation button and you will get the names of all the sheet.

nishith desai
http://www.pexcel.com

[ This Message was edited by: nisht on 2002-04-03 05:54 ]

[GeorgeB]

Hi Speedboy
I use check boxes on an intro screen. All the sheets are hidden until I check which one I want. It then appears. If you are interested re-post and I will step you through it.

[Dave Hawley]

Hi Speed boy


You may already know this, but you can right click on the 'tab scrolling buttons' to get a pop-up sheet menu.

[nisht]

My sheet is now not password protected you can download it and study the code.

It is a example utility.

nishith desai
http://www.pexcel.com

[stargazer]

George, I would appreciate your check box input, as I would like to add those to my workbooks. Thanks in advance. Bob

On 2002-04-03 06:05, GeorgeB wrote:
Hi Speedboy
I use check boxes on an intro screen. All the sheets are hidden until I check which one I want. It then appears. If you are interested re-post and I will step you through it.

[Speed boy]

Great code... How do I modify this to affect only the workbook where needed rather than a utility?

The help is greatly appreciated.
SB
On 2002-04-03 06:11, nisht wrote:
My sheet is now not password protected you can download it and study the code.

It is a example utility.

nishith desai
http://www.pexcel.com

[GeorgeB]

[GeorgeB]

OOPS
Got timed out again.

Hi Bob (Stargazer)

Sorry for the delay responding. Been out of town.
Here goes. I will step you through the procedure for one check box on a fresh workbook.
Adjust and multiply to suit.
Open a fresh workbook. From the forms toolbar place a checkbox on the sheet. Adjust it for size, caption etc. Right click on the check box and choose “Format control” Click on the “Cell link” box and choose a cell to link to. Lets assume H5 (put it any where you want but the code has to refer to the chosen cell). Put the following code into a standard module. Next right click on the checkbox, choose “Assign macro” click on this macro and press OK. Done

Public Sub HideMySheet()
'These routines hide or show the named sheets according
'to the condition of the corresponding check box on
'the INFO sheet
On Error Resume Next
Application.ScreenUpdating = False
Sheets("MySheet").Visible = Range("H5").Value
End Sub