my macros keep recording in Personal!

[awsumchillicrab]

They never used to, until I first wrote a macro in Personal.

Deleted all code in Personal already, but regardless of the excel sheet i try to record a macro in, it goes to Personal. It creates a Module 1 and writes it there.

How do I change this default location?

 

[prajul89]

Change store macro in "This Workbook" when you record a macro

 

[VoG]

When the record macro dialog box appears select This Workbook from the "Store macro in" dropdown.

 

[awsumchillicrab]

Thanks!

That was so easy, I was blind or something!