Workbook_BeforeSave help

[juster21]

I was messing around with this before and now I cannot shut off this event. I checked in the personal.xlsx and can't find this. Where is this stored? It fires when I close any Excel file

 

[pbarry]

Did you check ThisWorkbook module? That is where the workbook_open function operates.

 

[juster21]

ThisWorkbook is empty...which is why I'm so confused

 

[JoeMo]

What happens when you save the workbook to indicate a before save macro has fired or is it happening only when you close a workbook?

 

[juster21]

It happens when I close any workbook. I've looked in my personal.xlsb but there is nothing there. Could it be somewhere else?

 

[JoeMo]

My question was what is "It" - what happens when you close a workbook that convinces you an event macro has fired?

 

[juster21]

oh, sorry. It's placing text in a specific field...adds a row and then adds text in cellA3

 

[JoeMo]

oh, sorry. It's placing text in a specific field...adds a row and then adds text in cellA3

Are you sure you don't have a workbook before save event macro or a workbook before close event macro in the workbook?

 

[juster21]

Not that I can find.
I've looked in the code window but I don't see it anywhere. I realize how dumb this sounds but it's equally frustrating.

None of my macros do this...I've looked in all of the ThisWorksheet modules also.

Possible that maybe I saved this to a different location and it still get pulled into Excel on startup?

 

[JoeMo]

Have you tried closing Excel (all open instances) and then restarting it? Do you recall what you did when you were "messing around with this before"?