piers_morgan
New Member
- Joined
- Sep 3, 2003
- Messages
- 20
Hi all,
I have an annoying problem that must not be present for a file I am making for end users with little Excel expertise.
I have a file that copies a worksheet from it to another workbook. If the user saves the originator file (the file from which the worksheet was copied from), the dialog comes up as below...
Save 'XYZ' with references to unsaved documents message?
Clicking OK is all that is required. But this will confuse end-users and looks unprofessional.
I tried application display alerts false at BeforeSave. Breaking links via VBA. Nothing works. It doesn't matter whatsoever if it's saved with such references, based on how these files get used. So I don't understand why MS has made this one so difficult!
Any help much appreciated!
EDIT: I also tested the worksheet that gets exported by remove all formula and all VBA code. Same issue.
I have an annoying problem that must not be present for a file I am making for end users with little Excel expertise.
I have a file that copies a worksheet from it to another workbook. If the user saves the originator file (the file from which the worksheet was copied from), the dialog comes up as below...
Save 'XYZ' with references to unsaved documents message?
Clicking OK is all that is required. But this will confuse end-users and looks unprofessional.
I tried application display alerts false at BeforeSave. Breaking links via VBA. Nothing works. It doesn't matter whatsoever if it's saved with such references, based on how these files get used. So I don't understand why MS has made this one so difficult!
Any help much appreciated!
EDIT: I also tested the worksheet that gets exported by remove all formula and all VBA code. Same issue.
Last edited: