ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Enable Auto Refresh Message Box (https://www.excelbanter.com/excel-programming/403717-enable-auto-refresh-message-box.html)

Toydude5150

Enable Auto Refresh Message Box
 
Oh great Guru's of the Web...

I have just upgraded to Excel 2003 and I have two small annoying issues.

I have a worksheet that has a query to an external Access database (my
customer database) I have it set to auto-refresh on open and it does this
just fine. But now I always get a message prompt that asks me if I want to
enable auto refresh or disable. Is there any way to stop this annoying
message from popping up everytime I open the file?

I also have a toolbar that I have created that has some buttons with links
to excel files that I created and use everyday. Now whenever I click them I
get another annoying message saying how links are dangerous and only click if
I trust...yadda yadda yadda.. I trust myself...so is there a way to disable
this feature?


All times are GMT +1. The time now is 11:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com