Is there a way to change xlUpdateState programmatically,
from Automatic to Manual, for each link ?
As yet, I can only do via the UI (Edit > Links,
Ctrl-A to select all links, then click Manual).
Alternatively, is there a workbook-wide command that
I can use before a section of code, to say all links
manual update.
Then at the end of the code, say all links automatic update
I am using Excel 2003.
from Automatic to Manual, for each link ?
As yet, I can only do via the UI (Edit > Links,
Ctrl-A to select all links, then click Manual).
Alternatively, is there a workbook-wide command that
I can use before a section of code, to say all links
manual update.
Then at the end of the code, say all links automatic update
I am using Excel 2003.