Hello again...need help with identical changes to 62 different workbooks...
Posted by Dustin on May 03, 2001 12:28 PM
Good day all,
Hopefully someone can help with this. I need to make some common changes to 62 different workbooks.
The changes are:
- insert a row and text on a specific tab, and
- copy a tab from an existing tab, rename the tab (same new tab name for each of the 62 workbooks), and
- unprotect a sheet, rewrite a formula, copy the formula to a bunch of cells on the sheet, re-protect the sheet
- save the workbook
I have almost no experience with VBA and macros, but am willing to try to avoid spending the next 3 hours doing this manually.
Thanks in advance for your help.