Ronald Dodge
March 8th 06, 04:16 PM
I have an Excel file that I from time to time email between work and home.
At work, the system is using Excel 2002, SP3 on W2K Pro, SP4. At home, I use
Excel 2003 with the latest updates on XP Home Edition, SP2.
At work, I have no problems opening up this file and don't even get a single
dialog box as I have disabled all of the security stuff within Excel 2002.
At home, I have disabled all of the security stuff within Excel 2003, and I
still get a warning dialog box stated that the file may be harmful, all cause
it does have a macro in it that I personally have created and use. Here's
the steps taken to save the zipped folder and open it:
Select the email.
Save the attachment to the appropriate place on the system.
From within Windows Explorer, I open the zipped folder (that's how it
appears on Win XP as opposed to a Zipped file on W2K).
Double click the file.
I get the warning dialog box that also has the icon symbol like the XP
security settings within XP. I have gone into the Security settings from
within the Control Panel, disabled everything from within there as I have no
anti-virus program on the home system as strict rules are followed at home,
and I haven't had a security issue yet by following those strict rules
without the use of anti-virus programs. Now, I do use Spybot and Adaware for
spyware stuff.
NOTE: I also get this dialog box in it's uncompressed format outside of the
zipped folder when I double click on the file from within Windows Explorer.
My main question is: "What must I do to prevent this security dialog box
from popping up when I open an Excel file with a macro in it from within
Windows Explorer?"
Of course, I click on through it, but it's rather annoying to have to click
through it on a daily basis. I'm all for security within reason, but I'm
also one that don't like inefficiencies nor annoying things. That's one of
the reasons why I have created macros of various sorts so as to save me time
and allow for me to do other things, but then along with that, it's also
forced me to disable so much security stuff cause otherwise, it would
interfere with my codes. It's also not like I have hundreds or thousands of
dollars to pay for digitial signitures just to say that my own system can run
my own codes on a per year basis.
At work, the system is using Excel 2002, SP3 on W2K Pro, SP4. At home, I use
Excel 2003 with the latest updates on XP Home Edition, SP2.
At work, I have no problems opening up this file and don't even get a single
dialog box as I have disabled all of the security stuff within Excel 2002.
At home, I have disabled all of the security stuff within Excel 2003, and I
still get a warning dialog box stated that the file may be harmful, all cause
it does have a macro in it that I personally have created and use. Here's
the steps taken to save the zipped folder and open it:
Select the email.
Save the attachment to the appropriate place on the system.
From within Windows Explorer, I open the zipped folder (that's how it
appears on Win XP as opposed to a Zipped file on W2K).
Double click the file.
I get the warning dialog box that also has the icon symbol like the XP
security settings within XP. I have gone into the Security settings from
within the Control Panel, disabled everything from within there as I have no
anti-virus program on the home system as strict rules are followed at home,
and I haven't had a security issue yet by following those strict rules
without the use of anti-virus programs. Now, I do use Spybot and Adaware for
spyware stuff.
NOTE: I also get this dialog box in it's uncompressed format outside of the
zipped folder when I double click on the file from within Windows Explorer.
My main question is: "What must I do to prevent this security dialog box
from popping up when I open an Excel file with a macro in it from within
Windows Explorer?"
Of course, I click on through it, but it's rather annoying to have to click
through it on a daily basis. I'm all for security within reason, but I'm
also one that don't like inefficiencies nor annoying things. That's one of
the reasons why I have created macros of various sorts so as to save me time
and allow for me to do other things, but then along with that, it's also
forced me to disable so much security stuff cause otherwise, it would
interfere with my codes. It's also not like I have hundreds or thousands of
dollars to pay for digitial signitures just to say that my own system can run
my own codes on a per year basis.