Prompt user to select worksheet

[darkangl640]

Hello all!

I'm a newbie and need some help in Excel 2007. I'm not very familiar with macros or VBA, but I definitely know how to copy and paste code

I have a workbook with 6 worksheets: "Repair work in DC", "Repair work in MD", "Repair work in VA", "Construction in DC", "Construction in MD" and "Construction in VA". I would like the user to be prompted to select what type of work (repair or construction) and then which state (DC, MD or VA) so that the correct worksheet is displayed. If that's not an option (or too complicated to explain), then I just want all of the worksheets hidden when the file is opened and then prompt the user to select the correct worksheet (1 out of the 6 I previously listed).

I know this is probably very basic for many of you but I could really use the help!!

Thanks in advance for your time!!

[nathansav]

You will need to have a user form, which opens in the Workbook_Open event of the Workbook, this will then ask teh questions.

I presume from the question, you will have 2 questions, Which type of Work "Repair" or "Constructions" and then in what state, with answers "DC","MD" or "VA", then a button to click, which builds the worksheet name off this.

I have attached a demo

[darkangl640]

This is great, thank you so much!

Now I'm assuming I need to enter some coding, whether a macro or in VBA? Or is it just as simple as inserting a user form with the questions? Sorry....like I said before, I'm not good with this stuff!

[darkangl640]

Oh, nevermind, I see where you put the coding in. I'll give it a try....thanks!!

[darkangl640]

Ok, I'm going to throw in a monkey wrench. I would like all of my worksheets hidden when the file is opened, so the user HAS to make his selection before he can even see the worksheet that he chooses. Can you help me with that?

DISREGARD THE ATTACHMENT.....I FIGURED OUT WHAT MY PROBLEM WAS.

[nickmax1]

try this to see if its what you want.

[nickmax1]

If you dont want all sheets to be visible after the user selects the sheet they need (and just unhide the sheet they are after) change the code to the following:

Please Login or Register  to view this content.

[nickmax1]

If you dont want all sheets to be visible after the user selects the sheet they need (and just unhide the sheet they are after) change the code to the following:

Please Login or Register  to view this content.

OOPS duplicate post for some reason...mods please delete this one.

[darkangl640]

That is absolutely perfect and the 2nd code was EXACTLY what I needed! Thanks again for your quick reply!!!

[nickmax1]

glad to help.

please mark this thread as solved if you are happy.

[darkangl640]

Sorry, one last question (I hope). Is there a way to rename "CommandButton1" button to something else? Like "Go to selected worksheet", or simply "Go To"?

[darkangl640]

Nevermind....found it!! I will mark as solved. Thanks!!