How to create a button to open up selected sheets within a workbook

**Bill_T_W** · 12-03-2014, 07:16 AM

Hi all, firstly I apologise if my question is one of those where the answer is relatively simplistic, I find Excel is one of those things that if you don’t use it regularly you tend to forget the simple of tasks.

I’m trying to create a formula for a workbook that has a choice when you initially open the workbook depending on the type of cost sheet you require. For example if you select option A, the sheet(s) connected with option A will be the only sheets that are visible and accessible.
In anticipation, thanks for any assistance.

**mcmahobt** · 12-03-2014, 11:23 AM

Besides a macro, you could direct a user's navigation using buttons with hyperlinks to other worksheets embedded within them. For example, if sheet A corresponds to sheet 1, 2, and 3 (sequentially), and sheet B corresponds to sheet 4, 5, and 6 (all sheets have these names, so it would go MasterSheet, Sheet A, Sheet B, Sheet 1, Sheet 2, Sheet 3...), on the MasterSheet, you could have two buttons, one for Sheet A, and one for Sheet B. If a user selects, say Sheet A, the hyperlink will bring you to Sheet 1. Within Sheet 1 could be another hyperlink bringing you to Sheet 2, and so on.

Just a thought, hope this helps.

How to create a button to open up selected sheets within a workbook

LinkBack

Thread Tools

Rate This Thread

Display

How to create a button to open up selected sheets within a workbook

Re: How to create a button to open up selected sheets within a workbook

Thread Information

Users Browsing this Thread

Similar Threads

Button to create a graph of selected data.

Toggle Button on Workbook Open - value is True but button not pressed?

Create New Workbook Using Selected Sheets From Another Workbook

[SOLVED] How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook?

How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook?

Bookmarks

Bookmarks

Posting Permissions