How many ds can you find in:
Im trying to cancel a save if the user selects save and certain criteria are met. However, I would like them to be able to use save as (as the point of this macro is to prevent them saving a document without renaming it first).
Heres the tricky bit - the QuerySave event lets you cancel the save, but it doesnt check if save or save as has been used. BeforeSave lets you check if save or save as has been used, but it doesnt let you cancel the save.
Ive been experimenting (i.e. by adding the functionality into the event in a rather rudimentary fashion) but Ive not had any luck. And googling the issues unearths thousands of Excel VBA snippets where the BeforeSave event does exactly what I want it to do. Grrr...
If anyone has any bright ideas I would be very, very grateful!
Two, if you REALLY want to stop the user from doing this then you are wasting your time. The Object Model allows you to disable events completely, and X4 even comes with a nifty little button that you just push and then your event code will do nothing.
user
In that passage, there are twenty-four occurrences of the letter "d."
assistant