| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
code to unhide tabs based on cell contents
hi,
Private Sub CommandButton1_Click() sh = ActiveSheet.Range("E4") Sheets(sh).Visible = True Sheets(sh).Select End Sub -- isabelle Le 2011-08-25 16:02, pat67 a écrit : What about what i said in my second part? If i just want use the contents of a single cell as the named sheet to open? In other words, in cell E4 say they would enter NC-41282 and then i have a button that says "Edit". when they click the button, the NC-41282 tab is opened. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using cell contents to link to other tabs | Excel Worksheet Functions | |||
| Code to hide tabs based on input | Excel Discussion (Misc queries) | |||
| Have code check cell contents on edit. | Excel Worksheet Functions | |||
| Renaming tabs from particular cell contents | Excel Worksheet Functions | |||
| Hide or unhide sheets based on cell | Excel Discussion (Misc queries) | |||
Threaded Mode
