Morning all
I have had a Google around but I can't seem to find an answer to this (so maybe it can't be done). When I open my workbook I would like to supress the MS web query dialog box that asks if you want to enable the query because I would like to run a sheet unprotect and protect which I have put in some code that Hans kindly gave me earlier for refreshing all the queries with a button.
suppress web query dialog (2003 SP3)
-
steveh
- SilverLounger
- Posts: 1952
- Joined: 26 Jan 2010, 12:46
- Location: Nr. Heathrow Airport
suppress web query dialog (2003 SP3)
Steve
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin
-
HansV
- Administrator
- Posts: 78493
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: supress web query dialog (2003 SP3)
Best wishes,
Hans
Hans
-
steveh
- SilverLounger
- Posts: 1952
- Joined: 26 Jan 2010, 12:46
- Location: Nr. Heathrow Airport
Re: supress web query dialog (2003 SP3)
Thanks HansHansV wrote:Does You are prompted to enable automatic refresh when you open a workbook in Excel help?
Over lunch I had one of those moments and realised that some idiot (mentione no names
) had set the data properties to refresh on open. Same idiot is now going throw each data property to change it to not open. 
Steve
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin