Hi, Im in a little bind that need help.
Problem:
1) Need to identify any hidden sheets and unhide them.
2) Scroll to each sheets starting from the left most
3) identify if the sheet is protected.
Project scope.
Workbook contains between 15 to 25 worksheets.
Unhide all worksheets, then starting from the left most worksheet.
Scroll to each one. Unprotect the sheet if protected, then set the print area to print in single page, then protect the sheet again.
delete sheet if sheetname is Temp1, or work1, or work3, payplan, capture, "Extra (delimited)", or "Temporary (Last month)".
I hope that I have provide enough information here.
Thanks for any help...
Bookmarks