Disappearing macro

[KatPrichett]

Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I have written a macro which disappears when my colleague opens the excel document but it is still there when I reopen the document. When I initially created the document/macro, he had no problem opening and running the macro and then one day it just wasn't there anymore.<o></o>
<o></o>
I have checked his setting and Macro's are enabled - we are both running Office 2007 and the document is saved on a SharePoint site. The macro is very basic and just completes some format changes.<o></o>
<o></o>
Does anyone have any suggestions of what could be wrong please?<o></o>
<o></o>
Thanks<o></o>
Kat

 

[pboltonchina]

I assume you have the workbook saved in a .xlsm (macro enabled workbook) format?

 

[KatPrichett]

Yep, def .xlsm

 

[pboltonchina]

Do you have the macro in ThisWorkbook or a module in the workbook?

 

[KatPrichett]

If I've understood correctly, it is in a module in the workbook

 

[pboltonchina]

Sorry I'm stumped now. Hopefully someone else will pick up the thread for you.
Regards
Paul

 

[KatPrichett]

Ok, thanks for your help anyway

 

[pboltonchina]

Bump for Kat

 

[MrCastrovinci]

What happens if you copy and then paste it in a new document then save that as if you are starting from scratch? After he gets the new document does it still happen?

MrCastrovinci

 

[KatPrichett]

Ok, so I created a new workbook and simiply added a button and copied the code across - he could run the macro.
I also copied the original workbook onto our network drive to see if Sharepoint was affecting it but no luck - when he clicks on the option button to try and enable the macros he gets the following:

Security Alert
This file contains encrypted macros that have been disabled because there is no antivirus software installed that can scan them. To run these macros, remove the encryption or permission restriction on the file

There is no option to enable macros however after reading this it seems like there is something wrong with his antivirus software so have requested our help desk to look at this...i'll let you know the outcome!