CODEWITHSUNDEEP
excelvba
Mel Forsyth
Mel Forsyth

Reputation: 61

Excel, Stop vba that closes excel when it opens

I have a workbook where the client has set this code to run when it opens:

Public Sub workbook_open()
    Me.RefreshAll
    Me.Save
    Application.Quit
End Sub

I need to delete this script but as the macros have been enabled I can't get into the workbook to remove it. Is there any way to stop the vba code from running or deleting it?

Upvotes: 2

Views: 131

Answers (2)

Chenmunka
Chenmunka

Reputation: 815

As mentioned in a comment, if you hold down the shift key when you start Excel to open the workbook.

This disables macros, further hints are here.

Upvotes: 0

Siva
Siva

Reputation: 1149

Open another Excel sheet, Disable Macro Rules and then Try opening you Clients sheet.

Upvotes: 1

Related Questions