Thread: Hidden Sheets
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default Hidden Sheets

Try:
View Toolbars Customize Commands tab Macro

Then drag the smiley face to you toolbar and drop it between other
icons.

Click on it once and assign it to the sheets macro.

I don't add many macros to toolbars so there are probably some other
tricks you'll need to know but this should get you started.

Note if you are going to use this macro frequently, you should copy it
to you Personal.xls file so it is always available.