I have an Excel (ver. 2003) spreadsheet that needs certain fields populated before it can be saved or closed. I know I have to use the BeforeSave function, but I am unfamilar with it. I am also aware that macros need enabled and would like some help writing code that would lock the workbook and prompt the user to enable macros if they initially choose not to enable them. Thanks in advance for any help!!