How to open/create UIManagedDocument synchronously?

How do I create hyperlinks in Excel that open hidden worksheets?

• Managment is EVER so much fun to deal with. I have an Excel spreadsheet (using Excel 2010). I have five tabs that contain data. One of my bosses ONLY wants to see those five. I have a further 20ish tabs that contain more information. I have to have those hidden to satisfy boss #1. Boss #2 wants to easily access those without having to sift through all of the hidden sheets. I would like to create hyperlinks on the first page that will unhide and open the appropriate sheet. How do I do this? And, does it matter if I use the hyperlink() function or if I used the Insert->Hyperlink method? Many thanks for the help, anyone who can assist.

• Answer:

  Edit: to pursue your subsequent goals with the workbook, it would be better to correspond off list. Please email me at [email protected] Hyperlinks cannot activate hidden sheets. However, there is a pretty easy way to do as you wish using VBA. First, select a column on the first page and enter just the sheet names for the sheets you wish to hide/unhide. The following example uses column A (column 1) as the column holding the sheet names. Next, copy the following event handler to the clipboard (highlight the entire code, right click inside the highlighted area, and 'Copy'): Private Sub Worksheet_SelectionChange(ByVal Target As Range) On Error Resume Next If Target.Column = 1 Then Sheets(Target.Value).Visible = xlSheetVisible Sheets(Target.Value).Select End If End Sub Select the 'first page' and right click the sheet tab at the bottom. Select 'View Code' Paste the event handler into the white editing area to the right (right click in the area and 'Paste'). Still in the VBE, double click 'THIS WORKBOOK' in the VBA Project in the upper left quadrant. Copy this event handler to the clipboard: Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, _ ByVal Target As Range, Cancel As Boolean) ActiveSheet.Visible = xlSheetHidden End Sub Paste this event handler into the 'This Workbook' editing area to the right. Close the VBE (red button w/white 'x') Select your 'first page'. Click the cell containing any 'hidden' sheet name and that sheet will be unhidden and the active sheet. To hide the sheet again, simply double click any cell. Note: double clicking any cell in ANY sheet will hide that sheet. If you need to prevent certain sheets from being hidden, the code will have to be modified. Edit: about 'Management'.... keep in mind that 'Management' also has to deal with 'Management'. Everybody has a boss..... LOL! And it seems that the higher up you go, the less reasonable 'Management' becomes. At least that was my impression.