Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i download component to open vba project when using 2007? | Excel Discussion (Misc queries) | |||
VBA Project - Open/Close with Macro | Excel Worksheet Functions | |||
With VBA from Excel: Open Project, extract resource list and copy it to a worksheet, close project. | Excel Programming | |||
File, Open, View | Setting up and Configuration of Excel | |||
Locking project with workbook open? | Excel Programming |