Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 233
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Refresh MSQuery w/ Access datasource issue Chris B Excel Discussion (Misc queries) 1 June 29th 06 08:46 PM
Wait until MSQuery Refresh finished ChrisR[_2_] Excel Programming 1 September 19th 05 05:59 PM
Query Refresh message box on opening blonde1030 Excel Programming 1 September 13th 05 10:40 PM
refresh data command message Vince Stitt Excel Programming 0 June 2nd 05 10:31 PM
Refresh Pivot Table message Lucky[_4_] Excel Programming 0 December 4th 03 03:18 PM


All times are GMT +1. The time now is 10:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"