Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I sent a friend an Excel file which contained some macros.

She made some changes and sent it back to me, but somehow the macros have been removed.

Could it be possible that some file scanner or anti virus program removed the macros? Is there anyway I can verify?

share|improve this question
Please be more explicit. Were the macros in an addin, were they VBA code in the workbook, or something else? – Lance Roberts Oct 11 '11 at 0:10
What version of Excel are you using and are they using? And if you have 2007 or later, did you save the file as a macro-enabled file (.xlsm)? – music2myear Oct 11 '11 at 3:23

First, check the file extension. If it's XLS or XLSX, it's likely that she saved her changes to another file and didn't choose "macro-enabled workbook" (file extension: XLSM) while saving it.

enter image description here

It's also possible that your friend doesn't have macros enabled in Excel.

Here's how you can confirm it in MS Excel 2007:

  1. Press Alt > F > I
  2. Go to Trust Center > Trust Center Settings.
  3. Select either the 3rd or 4th option.
share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .