Suppress hyperlink Dialogue box when clicking on Link

[Brent E]

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,

 

[Gord Dibben]

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