H
Horatio J. Bilge, Jr.
I have a worksheet with several access queries.
I protected the worksheet to make sure that data and formulas aren't
changed, then wrote macros to run the queries. I added an unprotect and
protect statement to each macro, and it works great if I run the macros
directly (Tools-Macro-Macros...).
However, when I click "Refresh All" on the External Data toolbar, the
queries won't run because of the protection. If I manually unprotect the
sheet and click "Refresh All" it works fine, but doesn't reprotect the sheet.
I protected the worksheet to make sure that data and formulas aren't
changed, then wrote macros to run the queries. I added an unprotect and
protect statement to each macro, and it works great if I run the macros
directly (Tools-Macro-Macros...).
However, when I click "Refresh All" on the External Data toolbar, the
queries won't run because of the protection. If I manually unprotect the
sheet and click "Refresh All" it works fine, but doesn't reprotect the sheet.