View Single Post
  #8   Report Post  
Old August 26th 11, 12:43 AM posted to microsoft.public.excel.worksheet.functions
isabelle isabelle is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2011
Posts: 587
Default 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.