Unable to save workbook to the server with Macros

[former_member196865]

Hi Experts,

I have a workbook with a VBA code in it.

After I save it to the server, the Macros don't function.The button doesn't execute at all.

A local save of the workbook runs the Macros though. How do I resolve this issue?

[Shrikant_Jadhav · Accepted solution]

Hi David,

While saving file to server select file type as macro enabled ( right hand bottom ).

Shrikant

[Former Member]

Hi David,

did you saved the template in xltm format?

Regards

     Roberto

[former_member196865]

No.

XLSX.

Fixed now after I saved it as XLSM.

Thanks