Excel : Following a link to another workbook

[LittleSmudge]

Background:
I have a workbook which is the summary of 10 separate other workbooks.

Each low level workbook is a departmental budget/performance summary.

The top level is the combination of them all.

When a user opens the top level workbook ( and supplies the password ) they see a page of numbers. These numbers link to the other worksheets.
( I've sorted out getting Excel to supply all of the unique passwords to the ten underlying workbooks when it refreshes )

By double clicking in one of the linked cells Excel follows the link and opens up the linked workbook in its own window. Asking for a manual password entry this time.
- At leastways it does on MY machine because I have REMOVED the "Edit directly in Cell" option from the Tools Menu, Options, Edit tab.

However, I have a user who likes the 'Edit directly in Cell' functionality - there has to be one doesn't there !


So my question is -
Is there a way of getting Excel to follow the link on his machine even though his setting is in "awkward mode" ?




G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[GlennUK]

Firstly, I have to say that the best thing to do is persuade your user that Edit Directly In Cell being switched off is the best thing to do. I've been used the double-click functionality for navigating links and formulae for years, ( you know, using <F5><Enter> to navigate back to where you've just come from too ), and there is nothing else that comes close.

The alternative ( rubbish as it is ), is to have all the supporting workbooks open ( as this navigation method does not navigate to closed workbooks ), and use the auditing tools to trace precedents, and double-click on the graphic item indicating the source link which will display a list of the references that are precedents for the cell, and double-click the one you want to navigate to.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[LittleSmudge]

As the troublesome users is the MD of the partnership I was reluctant to tell him 'Do it my way or don't do it' if there was a simple keyboard combo available to do this trick that I hadn't been aware off.

I'd half expected someone to come back with something like :-

"Hold the Alt Key down then press Tab whilst double clicking in the Cell and that overrules the 'Edit directly in Cell' for that one action"
It's a standard Excel keyboard combo - didn't you know ?

But as no one has it's time for Log Book down the back of the trousers and go face the MD !




G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[GlennUK]

If you do Ctrl-[ Excel will navigate to precedents, but not to closed links.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[dhulbert]

If you make use of

Application.EditDirectlyInCell = False

and

Application.EditDirectlyInCell = False

to the top level workbook you can turn the functionality on or off depending on which page the user is looking at...

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)