View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
only possible with VBA. Try for example the following

sub unhide_all()
dim wks as worksheet
for each wks in activeworkbook.worksheets
wks.visible=true
next
end sub


--
Regards
Frank Kabel
Frankfurt, Germany

ahonig wrote:
I'm working in a workbook with multiple hidden sheets. I have to
unhide all of them and delete most of them. It's time consuming
doing this individually and I can figure out how to unhide all of
them at once. The control and shift keys do not work with this
function. How can I unhide all my hidden sheets at the same time?