PDA

View Full Version : VBA code disaappeared.



Ladderman451
01-03-2017, 08:57 AM
Have been using an automated workbook for past 3 years to gather information. There are a number of macros built into the workbooks which until now have worked successfully. I have saved 395 workbooks over the years. The work books were originally excel 97 2003 and I have been using excel 2016 for past six months with no problem. Now suddenly the code is missing from every workbook on my laptop. Any ideas why this should happen? Luckily I did a backup not so long ago and the workbooks on the external drive still have the code in them.

snb
01-04-2017, 01:53 AM
Did you save as .xlsx ?

Ladderman451
01-04-2017, 06:33 AM
No xls. Hasn't been a problem until now. Never had any warnings about saving it as an xls.

snb
01-04-2017, 07:30 AM
VBA code doesn't disappear spontaneously.

SamT
01-04-2017, 08:39 AM
Malware on your laptop? :dunno