Link Problem

T

Todd Huttenstine

Below is a post from last night. How do I do what Tom
Ogilvy has said?

Thanx

Ok, I can reproduce that.

for the worksheet, change the EnableSelection Property to
either
xlUnlockedcells or xlNoSelection

then you will get the message on a double click, but it
shouldn't try to
open the linked workbook.

Note that this property must be set each time the workbook
is opened - so
you would need to do it in the workbook_open event or
other appropriate
event. (of course if macros are disabled - no go).

--
Regards,
Tom Ogilvy



Todd Huttenstine <[email protected]>
wrote in message
 
Top