View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Grd Grd is offline
external usenet poster
 
Posts: 118
Default How to unhide multiple sheets in one go

Hi,

I have multiple sheets in a workbook hidden and at times I need to unhide
them all in one go.

However the problem with the unhide feature is that it only allows you to
unhide one sheet at a time. I have over 22 hidden sheets so this is a real
problem for me.
I've tried doing some VBA but got stuck. Could'nt get it to work.

Anyone done this before or could give me hints

Thanks in advance
Sandra