CODEWITHSUNDEEP
vbaexcel
Ruby Harris
Ruby Harris

Reputation: 87

How to open a file with Application.Close?

I stupidly put Application.Close to run when WB is opening and now I can't get to my own file and code. What do I do?

Macro in ThisWorkbook:

Private Sub Workbook_Open()
    Application.Close
End Sub

Upvotes: 1

Views: 44

Answers (1)

Andrey Ampilogov
Andrey Ampilogov

Reputation: 382

Simply disable macros in Excel, open the file and erase the line :)

More information on disabling macros:

https://support.office.com/en-us/article/enable-or-disable-macros-in-office-files-12b036fd-d140-4e74-b45e-16fed1a7e5c6

Upvotes: 2

Related Questions