Any BeforeSave capability without VBA code??

[PB7]

Hello.

I am familiar with using BeforeSave, to prompt a user to do something, before saving an Excel file.

However, is there a non-VBA way, so-to-speak, to do this in an Excel file?

I have an electronic form, based on a spreadsheet, to be used by a large community. My fear is some users will not enable macros when opening the file, and thus not allow a VBA module with BeforeSave to work right.

I've looked at Excel options and data validation, and there doesn't seem to be any available settings that would allow this. Any thoughts?

Thank you in advance for any feedback here.

 

[BobUmlas]

You can ensure your workbook will only be opened with macros on or they can't use it. It requires VBA code to set it up, but none to use it. that is, your users won't be able to save your file without your BeforeSave capability kicking in, since macros would have to be enabled. If you want the section from my upcoming book, "Excel Outside the Box", send me an email to email address removed <EMAIL removed address>requesting the writeup of how to ensure macros are enabled.

 

[PB7]

Thanks Bob very much, I will proceed as suggested. Will send an email.

 

[BobUmlas]

I haven't received an email yet...

 

[Joe4]

I removed your email address from the post. If you wish to share your email address with someone, it is best to do so via Private Messages. The reason because Spammers routinely troll public forums such as this looking for email addresses to harvest and Spam.

So unless you really enjoy getting Spam, you never should post your email address to a public internet site.

 

[BobUmlas]

OK, I don't think a spammer would pick this up. I can be reached at here if you remove the x's:
bxoxbxuxmxlxaxsx@xhxoxtxmxaxixlx.xcxoxm