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


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=181547

Microsoft Office Help