Excel GUI

[morerockin]

I have done some searching but couldn't find what I was looking for.

I am looking for a thread that explains on how I can create a GUI within a sheet in a workbook. The buttons within the sheet would take me to other sheets in my workbook.

[zbor]

1. Inser shape
2. Right click on that shape -> Hyperlink
3. In left bar choose: Place in this document
4. Choose desired sheet
5. OK

[morerockin]

Wow . . can the sheets be hidden? I have a ton of tabs and would like to hide them all and just create one sheet on a page that links to all of my tabs via buttons that you have shown above.

[zbor]

You will need macro to hide/unhide sheets but generaly yes, they can.

[morerockin]

Zbor,

See attached. Book3.xlsm

Each shape links to another hidden sheet within the workbook with the exception of the first shape. I have created a macro within the first shape.

Goal: When clicking on the button, it will unhide and display the sheet.

How would I do this? Would I create a macro that unhides and displays the sheet and then assign that macro to the shape I just created? Essentially, I wouldn't need to create hyperlinks in the shape, just assign macros? I have done this in the first shape but it says "reference is not valid" when I click the shape.

When finished viewing the sheet, I would like for the sheet to become hidden again and only the Main Menu tab be displayed.

How would I do this? I really don't have a solution for that.

[zbor]

You got error because there was no Sheet2 (only sheet1, sheet3 etc).

Anyway you can change button name and use only one macro that will recognise button name and then select that sheet.

I've create macro that will unhide sheet with button name.
If it's unhiden it will hide it.

If doesn't exist you will get info about that.

And yes, you need to remove hyperlinks in this case.

Please test it.

Please Login or Register  to view this content.

[morerockin]

Zbor,

That macro is hard for me to understand, but it does work. If I create more buttons how do I get them setup with that macro?

Next question. I need a macro to hide all worksheets except Main Menu. I will use this to exit the worksheet that I am in and return me to the Main Menu tab.

[morerockin]

Or hide the active sheet and return me to the main menu sheet

[morerockin]

Or hide the active sheet and return me to the main menu sheet

I know how to hide active sheets: ActiveSheet.Visible = xlHidden

Now I just need to understand how to add more buttons and macros

[zbor]

If I create more buttons how do I get them setup with that macro?

Insert button.
Name it by desired sheet.
Assign macro called "Unhide_sheets

Example is button with name sheet3. Try with other.

I need a macro to hide all worksheets except Main Menu.

Created macro Hide_All_Sheets and assigned to red/blue button.

Please Login or Register  to view this content.

Or hide the active sheet and return me to the main menu sheet

Insert button in desired sheet and assign macro named hide_sheet

Naming button is not important as for first macro.

Please Login or Register  to view this content.

[morerockin]

Book3 (2).xlsm

Zbor. It worked when I added a new button (see sheet 6)

However, when I tired modifying the existing button (now labeled sheet5), it wouldn't work. See attached above.

thank you!!

[zbor]

See Post #6

And yes, you need to remove hyperlinks in this case.

[morerockin]

I should probably create a new post for this but how do I hide the grid lines and control the viewing area so only a certain range is viewable on my main menu tab?

[zbor]

Yea, you better open new thread because discussion ca get copmlicated.

If this take care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[morerockin]

Yea, you better open new thread because discussion ca get copmlicated.

If this take care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Will do, thanks Zbor