I created a form (to be used like a template) in Excel
(saved as xls. not xlt.) In order to ensure that the form
is filled out in it's entirety, I wrote a code in VBA
(using BeforeSave) that will not allow the file to be
saved if certain cells are blank. Unfortunately though, I
am now unable to save my file for others to use...since
these cells are blank. They need to be blank when the
file is open, so that others can fill them in. Any
suggestions would be greatly appreciated. Please help.
Thank You.