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,

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,