T Tracey Feb 26, 2004 #1 Is there a way to unhide all hidden worksheets on workbook without going through "unhide" each time?
B Bob Phillips Feb 26, 2004 #2 Only with VBA For Each sh in Activeworkbook.Worksheets sh.Visible = xlVisible Next sh -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
Only with VBA For Each sh in Activeworkbook.Worksheets sh.Visible = xlVisible Next sh -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
