How to open or view VBA project only
 

Is it possible to open a VBA project for viewing only (even when it is
associated with a spreadsheet)? So without activating the macro (in case
there is a macro initiated by an Open event). In this way it would be
possible to check the macro for "virusses".

Thanks in advance,

Jan Bart

How to open or view VBA project only
 

Why would you not just virus check the Excel workbook?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Excelerate-nl" wrote in message
...
Is it possible to open a VBA project for viewing only (even when it is
associated with a spreadsheet)? So without activating the macro (in case
there is a macro initiated by an Open event). In this way it would be
possible to check the macro for "virusses".

Thanks in advance,

Jan Bart

How to open or view VBA project only
 

Hi Jan,

I'm not sure what you mean by " (even when it is associated with a
spreadsheet)" as distinct from "not associated".

To disable open events in Workbook_Open or Auto_Open events, when the macro
virus warning appears hold Shift, allow Enable macros and open the file.

Regards,
Peter T



"Excelerate-nl" wrote in message
...
Is it possible to open a VBA project for viewing only (even when it is
associated with a spreadsheet)? So without activating the macro (in case
there is a macro initiated by an Open event). In this way it would be
possible to check the macro for "virusses".

Thanks in advance,

Jan Bart

How to open or view VBA project only
 

Hello Bob,

My virus checker does not react on for instance the Kill command in my VBA
script. So virus checking does not make sense......

I find the option of using the Shift key when selecting Enable Macro's to
disable the Open event, a reasonable secure step in opening an Excel sheet
from an unverified source.
However i am still looking for an option to view the code without opening.
Do you have any clues??

Regards,

Jan Bart

"Bob Phillips" wrote:

Why would you not just virus check the Excel workbook?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Excelerate-nl" wrote in message
...
Is it possible to open a VBA project for viewing only (even when it is
associated with a spreadsheet)? So without activating the macro (in case
there is a macro initiated by an Open event). In this way it would be
possible to check the macro for "virusses".

Thanks in advance,

Jan Bart

How to open or view VBA project only
 

Or just change macro security to the highest setting (temporarily).

This will stop all macros--even after the workbook is opened.

Excelerate-nl wrote:

Is it possible to open a VBA project for viewing only (even when it is
associated with a spreadsheet)? So without activating the macro (in case
there is a macro initiated by an Open event). In this way it would be
possible to check the macro for "virusses".

Thanks in advance,

Jan Bart

--

Dave Peterson

How to open or view VBA project only
 

Peter T wrote:
Hi Jan,

I'm not sure what you mean by " (even when it is associated with a
spreadsheet)" as distinct from "not associated".


He is looking for a vba viewer, similar to xls viewer.
No, I don't know any.
Im not sure if such exists.