Excel VBA Run-time Error ‘32809’ – Trying to Understand it

In my case following helped:

  1. Save file as .xlsx (macro-free) – all macros would be erased while saving;
  2. Open source file with macros and copy modules to the .xlsx file;
  3. Save file as .xlsm – full recompile performed.

Afterwards everything started working normally. I had file with 200+ sheets and 50+ macros and posting comments in each module didn’t help, but this solution worked.

Leave a Comment