Lassebasse
New Member
- Joined
- Oct 23, 2014
- Messages
- 16
Hi everyone,
Maybe a cryptic Title but I'll explain:
I Use "Application.Dialogs(xlDialogSaveAs).Show(filename)" (containing prompted filename) to open Dialog window Save As.
Now, I want to detect if that filename in an way is changed before hitting "OK" to save (actually I want to prevent/stop any change of the filename).
Can I lock the filename to the prompted one, or at least exit code if any change is made to the filename before hitting "OK"?
Thank you in advance!
Regards
lassebasse
Maybe a cryptic Title but I'll explain:
I Use "Application.Dialogs(xlDialogSaveAs).Show(filename)" (containing prompted filename) to open Dialog window Save As.
Now, I want to detect if that filename in an way is changed before hitting "OK" to save (actually I want to prevent/stop any change of the filename).
Can I lock the filename to the prompted one, or at least exit code if any change is made to the filename before hitting "OK"?
Thank you in advance!
Regards
lassebasse