How can I bypass a pop-up

**SAsplin** · 11-16-2009, 07:49 AM

Can anyone help with a problem I am experiencing -

I have a master workbook that is linked to a number of slave workbooks. However, whenever you open one of the slave documents you get a pop-up message:

"Unable to open://master filepath. The Internet site reports that the item you requested could not be found. (HTTP/1.0 404).

Is there any way I can put in a piece of code to tell the workbook to ignore this pop-up upon opening as I don't really want the users of the slave workbooks to know there's a master one!!

Thanks

Steve

**broro183** · 11-16-2009, 08:18 AM

hi Steve,

maybe

Please Login or Register  to view this content.

hth
Rob

**SAsplin** · 11-16-2009, 08:35 AM

Rob -

Thanks for having a go at that one. Unfortunately it didn't work.

Any other ideas?

Thanks

Steve

**Whizbang** · 11-16-2009, 09:58 AM

On Error Resume Next doesn't work?
http://www.cpearson.com/excel/ErrorHandling.htm

Also, just to double check, what do you mean by "Unfortunately it didn't work". I just want to double check that you used "application.display alerts = false" at the beginning of your code block, and "application.display alerts = true" at the end of the code block, not copied exactly as Rob supplied.

**SAsplin** · 11-16-2009, 10:41 AM

Whizbang -

Thanks for your post. My workbook actually comes up with two alerts;

1. The aforementioned alert about not being able to open....
2. An alert that states that one or more links cannot be updated...

Rob's solution above seems to bypass the second alert but not the first.

I've tried entering an 'On Error Resume Next' command based on the document you enclosed (thanks) but to no avail. Unless I'm entering it wrong, which is highly possible as VBA is very new to me!

Cheers

Steve

**SAsplin** · 11-16-2009, 10:44 AM

Whizbang -

Actually, my workbook comes up with two alerts:

1. The abovementioned alert about being unable to open...
2. An alert stating that one or more links cannot be updated...

Robs solution above seems to disable the second alert but not the first.

I've tried entering a 'On Error Resume Next' command based on your enclosed document (thanks) but to no avail. Unless of course I'm entering it wrong, which is highly possible as I'm quite new to VBA!

Cheers

Steve

**SAsplin** · 11-16-2009, 12:06 PM

Ok - I think I see the problem.

As there is no other VBA code within this workbook it's pointless using application.displayalerts = False
application.displayalerts = True
as there's no code in the middle, so it just turns the alerts off and then straight back on again!

I don't really want to keep the alerts turned 'off'.

Suggestions?

**broro183** · 11-16-2009, 06:30 PM

hi,
In Excel 2007 you may be able to use Tools - Options (ie [alt + T + O]) - Advanced - "When calculating this workbook" - untick "update links to other documents" & tick "save external link values".
I think this setting is stored within the active workbook & not at an application level but you should check... also, with these settings you (or someone) would have to force an update of the links (edit: in the slave files) at any time a change is made in the Master file.

hth
Rob