Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsQuery Refresh Message
I have a worksheet with msquery. I get the Query Refresh Message asking do I
want to enable ot disable automatic refresh. How can I elimnate this message from appearing. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsQuery Refresh Message
You cannot disable this message, it is a security feature.
You could instead refresh from code on opening the workbook in an auto_open proc. or workbook_open event, but then you would get a VBA warning instead. This VBA warning can be circumvented with a digital security certificate, or by lowering your VBA security settings. DM Unseen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refresh MSQuery w/ Access datasource issue | Excel Discussion (Misc queries) | |||
Wait until MSQuery Refresh finished | Excel Programming | |||
Query Refresh message box on opening | Excel Programming | |||
refresh data command message | Excel Programming | |||
Refresh Pivot Table message | Excel Programming |