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?
|