Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a new spreadsheeet we're using for data entry and have discovered a
few errors in formulas in it. Unfortunately, there are now more than 500 copies of it distributed to our staff. I am hoping someone can help me find a macro solution to batch fix my errors. The sheets in question are protected with a password, which seems to complicated matters. Is it possible to creat a macro that will: 1. run on an entire folder of workbooks 2. unprotect the sheet when run 3. make the corrections to the formulas in question 4. reprotect and close the sheet I can provide additional information on the spefic changes that need to be made, but I thought I'd first see if what I want to do is even possible. Thanks in advance. spence |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Links to password protected workbooks | Links and Linking in Excel | |||
Link Password Protected Workbooks | Excel Discussion (Misc queries) | |||
password protected file with pivot table errors | Charts and Charting in Excel | |||
Excel Macro to open password protected workbooks? | Excel Discussion (Misc queries) | |||
Password protected workbooks | Excel Discussion (Misc queries) |