Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.