Suppress hyperlink Dialogue box when clicking on Link
Good Morning,
I have a spreadsheet that has a col of hyperlinks. This file is read only and will be shared by many users. Every time a link is clicked, a dialogue box appears prompting user whether or not they want to open the webpage. Is there a macro or VBA code to suppress this box from appearing and go directly to the web page? Thanks, |
Suppress hyperlink Dialogue box when clicking on Link
I think you have to turn that off for the Office Application globally.
See this KB Article for preventing the alerts for hyperlinks. http://support.microsoft.com/kb/829072/en-us Gord Dibben MS Excel MVP On Thu, 16 Oct 2008 10:25:01 -0700, Brent E wrote: Good Morning, I have a spreadsheet that has a col of hyperlinks. This file is read only and will be shared by many users. Every time a link is clicked, a dialogue box appears prompting user whether or not they want to open the webpage. Is there a macro or VBA code to suppress this box from appearing and go directly to the web page? Thanks, |
All times are GMT +1. The time now is 07:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com