| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unprotect sheet to "Refresh All" Access queries
Thanks! That was simple.
"Per Jessen" wrote: 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 "Horatio J. Bilge, Jr." skrev i meddelelsen ... 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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
| how do i join 2 "dqy" type queries in excel 2003 | Excel Worksheet Functions | |||
| Web Queries and how Excel sees the "selected box" on the web page | Excel Discussion (Misc queries) | |||
| Data Refresh Issues when linking Access queries to Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
