DaleWatson123321
Programmer
BACKGROUND:
As we know, Excel allows for what Microsoft calls "Macro virus protection" ( under Tools - Options - General ).
However, this option is really NOT "virus protection" in the same sense as the protection offered by Norton or McAfee virus protection software which actually tests for the existence of known viruses.
Microsoft's "Micro virus protection" is nothing more than an option to "disable" VBA code which could be attached to a file. This is a VERY "short-sighted" and "short-term" solution which Microsoft has to be expected to change - and SOONER rather than later.
Currently, the recipient of a file from an unknown sender has to risk opening a file that contains VBA code if the recipient wants to take advantage of the VBA code. The ONLY other option is to use Microsoft's "virus protection" which simply opens the file WITHOUT loading the VBA code.
QUESTION:
Does anyone know of any option in Excel, or elsewhere (including third-party software), to gain access to the VBA code - to VIEW it WITHOUT actually running it ? ? ?
Of course such an option makes perfectly GOOD sense, and it's another clear example of what Microsoft SHOULD include.
My best hope would be that Microsoft ALREADY has an option to simply VIEW the VBA code, and that they have simply NOT made this option very visible. However, I expect this is NOT the case.
Does anyone know of any other options ? If NOT, perhaps our ONLY option is to ATTEMPT to get Microsoft's ATTENTION - to get them to include a "VIEW-ONLY" option for VBA code. This would be a tremendous improvement to Microsoft's current "Macro virus protection" ...which REALLY should have been called "Disable Macros".
Even if you don't have any "solutions" to this "limitation" of Excel, I (and I believe other Tek-Tippers) would appreciate your comments on this subject.
If I don't respond to your postings in the near future, it's because I'll be away for 5 weeks - on a vacation to Queensland in Australia (Great Barrier Reef and all).
But I'll be anxious to read your responses when I return, (or perhaps sooner if I can "find an internet connection on the Reef or in the 'outback'"
.
Thanks for your contributions.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
As we know, Excel allows for what Microsoft calls "Macro virus protection" ( under Tools - Options - General ).
However, this option is really NOT "virus protection" in the same sense as the protection offered by Norton or McAfee virus protection software which actually tests for the existence of known viruses.
Microsoft's "Micro virus protection" is nothing more than an option to "disable" VBA code which could be attached to a file. This is a VERY "short-sighted" and "short-term" solution which Microsoft has to be expected to change - and SOONER rather than later.
Currently, the recipient of a file from an unknown sender has to risk opening a file that contains VBA code if the recipient wants to take advantage of the VBA code. The ONLY other option is to use Microsoft's "virus protection" which simply opens the file WITHOUT loading the VBA code.
QUESTION:
Does anyone know of any option in Excel, or elsewhere (including third-party software), to gain access to the VBA code - to VIEW it WITHOUT actually running it ? ? ?
Of course such an option makes perfectly GOOD sense, and it's another clear example of what Microsoft SHOULD include.
My best hope would be that Microsoft ALREADY has an option to simply VIEW the VBA code, and that they have simply NOT made this option very visible. However, I expect this is NOT the case.
Does anyone know of any other options ? If NOT, perhaps our ONLY option is to ATTEMPT to get Microsoft's ATTENTION - to get them to include a "VIEW-ONLY" option for VBA code. This would be a tremendous improvement to Microsoft's current "Macro virus protection" ...which REALLY should have been called "Disable Macros".
Even if you don't have any "solutions" to this "limitation" of Excel, I (and I believe other Tek-Tippers) would appreciate your comments on this subject.
If I don't respond to your postings in the near future, it's because I'll be away for 5 weeks - on a vacation to Queensland in Australia (Great Barrier Reef and all).
But I'll be anxious to read your responses when I return, (or perhaps sooner if I can "find an internet connection on the Reef or in the 'outback'"
.Thanks for your contributions.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca