Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm looking to prevent an Excel document from being saved if a particular cell (say F5) is not filled out. However, I cannot use a macro, as I'm providing this document to users to fill it out as a form. If the user does not enable macros, the macro will be pointless. I need to be able to do this without a macro.

The Data Validation option is unacceptable as if I initially leave the field blank (don't touch it in the first place) then it doesn't warn the user.

Is it possible to do this without a macro?

share|improve this question

Short answer -- No, it's not possible without using VBA.

Even with VBA, it would be easy to prevent the user from doing a "Save As" but difficult to prevent him from doing a regular "Save." For instance: the user has AutoSave enabled.

share|improve this answer

I would use Conditional Formatting, like have a big red border around the cell, until a value is entered.

share|improve this answer
This is a good way to show what still needs to be done – datatoo Jun 15 '11 at 15:20

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.