Unprotect sheet to "Refresh All" Access queries

  • Thread starter Thread starter Horatio J. Bilge, Jr.
  • Start date Start date
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.
 
Hi

If I understand you right, add a button from the command button menu to your
sheet and use it to call your macro.

Hopes it helps.

Regards,
Per
 
Thanks! That was simple.


Per Jessen said:
Hi

If I understand you right, add a button from the command button menu to your
sheet and use it to call your macro.

Hopes it helps.

Regards,
Per
Click to expand...
 
Back
Top