emailing spreadsheet with macros

[natanz]

i have worked out some code to send a link to a spreadsheet to my
manager to get his signature. I placed a command button in that
spreadsheet to automate the signing process for him. the problem i am
having though, is if s/he opens the spreadsheet from the link in the
email, the file opens, but macros are disabled. if the manager goes
out and opens the file from its network location it does fine and the
command button works. I am sure this has to do with security issues
in outlook, but maybe there is a way to work it out.

Thanks for your help.

natan

 

[joel]

Often comapnies ahave firewall software that disable macro i
workbooks. the method I often use is to change the extension on th
file before sending the workbook. Instead of xls use slx and tell th
person whjo recieves the file to rename the file. Zipping the fil
before sending it "sometimes" gets through depedning how suffisticate
the gateway software is. Recently one of my macros was detected as
virus. I was using one of chip Pearson techniques for modifying macro
using VBA and had to zip the file to get the person to receive the fil
unaltered.