I have about 200 files, all built from the same template.
Each file has a tab called "Data Map", which is xlVeryHidden. Both the VBA code and the "Data Map" sheet are protected with different paswords, although the same 2 passwords are used in every file.
Does anyone know of an easy way to unhide the "Data Map" sheet in every file and unprotect it, other than manually times 200?
Thanks for any suggestions!
Each file has a tab called "Data Map", which is xlVeryHidden. Both the VBA code and the "Data Map" sheet are protected with different paswords, although the same 2 passwords are used in every file.
Does anyone know of an easy way to unhide the "Data Map" sheet in every file and unprotect it, other than manually times 200?
Thanks for any suggestions!