VBA Code for Selecting sheets

Speed boy

New Member
Joined
Apr 2, 2002
Messages
29
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?
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
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.

ni****h desai
http://www.pexcel.com
This message was edited by nisht on 2002-04-03 05:54
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
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.

ni****h desai
http://www.pexcel.com
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,563
Messages
6,114,332
Members
448,566
Latest member
Nickdozaj

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top