PDA

View Full Version : All VBA Code Stopped Working



lm8
12-15-2016, 01:19 PM
So I finished my Excel workbook/document and it looked final. I needed a bunch of different copies of this specific workbook with different file names. I went and began making the differently named files by going to File and then Save As.

When I was part way through creating the new files (saved as .xlsm types), I noticed none of my VBA code was working (data from sheets wasn't populating to labels, etc.)--even in the original file!

I went into my Trust Center settings and changed them, so macros and VBA code should be enabled. Right now I can't think of what I possibly could have managed to mess up. :eek: Any ideas?

Thanks in advance :)

Leith Ross
12-15-2016, 03:05 PM
Hello lm8,

What system or error messages did you receive?

By default, Windows does not show the file extensions in Explorer. It could be you thought the file was being saved as an XLSM but was in fact saved as XLSM.XLSX.