Open Excel and Bypass VBA code

Topic

New Reply

I have an excel spreadsheet that has an On Open event. This event kicks off a series of macros and code to do alot of data gathering from an Access database and then saves the workbook as another workbook without macros and then closes the original workbook. My issue is now, I have to get into the workbook and make modifications to the code. I can not open it as it runs the macros and code. Is there a manual way (like in Access holding down the Shift key) to bypass the vba and macros?

Thanks,
Cindy
York, PA

Reply | Quote

Replies

Cindy,

One way to do it is to open Excel
Press Alt+F11 to get into the VBA Editor
In the immediate window use the workbooks.open command to open the workbook.

Ex: workbooks.open “d:pathfilename.xls”

If the Immediate window isn’t visible use the View menu or press Ctrl+G

RG

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Hi Cindy

pressing Shift when opening the workbook should work in Excel too.

alternatively, drop your office security settting to medium and when prompted to enable/disable macros, choose disable….

Cheers
Phil

Reply | Quote