Excel crashing on opening

[Chewyhairball]

Hi
I recently added the following to Workbook_Open to run when opening the sheet

Application.MoveAfterReturn = False

when i try and open my file now it crashes. If i open it in safe mode and remove this line of code it works again.

Why would this line of code crash the sheet when opening?

thanks

Rory

 

[Legacy 143009]

Maybe it is conflicting with another event. Try:

Private Sub Workbook_Open()
  Application.EnableEvents = False
  Application.MoveAfterReturn = False
  Application.EnableEvents = True
End Sub

 

[Alex Blakenburg]

I am just curious, on your profile you are running 2 versions of Excel. Is it happening on MS365 or O2016 ?

 

[Chewyhairball]

I am just curious, on your profile you are running 2 versions of Excel. Is it happening on MS365 or O2016 ?

365

 

[Chewyhairball]

Maybe it is conflicting with another event. Try:

Private Sub Workbook_Open()
  Application.EnableEvents = False
  Application.MoveAfterReturn = False
  Application.EnableEvents = True
End Sub

Hi

Didn't seem to make a difference. Very odd! I think ill just not use it