Where should I put the module Workbook_BeforeClose?

[USAMax]

I need to protect only cells in column A starting on row 13 that are not blank when the workbook closes.

I have read many links on this subject but it will not work. Workbook.BeforeClose Event (Excel)

It always prompts me to save the document and never protects the cells when I close it.

I tried to save it at the workbook level but I am not sure how to do this.

I saved it on the worksheet, didn't work.

I saved it within a module, again didn't work.

Where should the module be placed?

 

[JoeMo]

Goes in Thisworkbook which is found in the VB Editor under your project in the folder Microsoft Excel Objects.

 

[USAMax]

Sorry everyone, I found a site that answered my question: Run VBA Macros When A Spreadsheet Opens or Closes — The Spreadsheet Guru