View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bill_S Bill_S is offline
external usenet poster
 
Posts: 30
Default macro to unhide a sheet

I've found a great macro on this forum to unhide a hidden sheet:

Sub Button12_Click()
Sheets("C H M").Visible = True
Sheets("C H M").Activate
End Sub

My concern is I will have to paste this button on a large and constantly
growing number of sheets that our clerks will use. Is there a way I could
add this command to the actual menu at the top of the screen so it can always
be in one spot for the clerk and not a button pasted on hundreds of sheets?