Hi Gurus,
Is there a way I can have a checklist option for each and every sheet within workbook:
Basically, I want to:
1.) Open the Workbook - on open, have an 'option box' pop up and list every available sheet [by name] in the entire workbook.
2.) I then want to select the sheets I want to keep (and then work on) on this occasion, and have all the unchecked - therefore unwanted - sheets deleted.
3.) If i can also have a text search/replace at this point it would be amazing: find/replace TITLE [workbook] with: "whatever i choose"
That's all folks!
I have a geopostcode sheet that is hidden within the workbook, that i need to still be there after the above - FYI
Any help is greatly appreciated,
Thanks
Alix
Bookmarks