Running a Macro from Page Layout View Causes Excel to Crash

[AndrewWalker]

Hi All,

I'm running a very simple Excel macro to go back to the menu screen of the file. There are several worksheets in the file, and all have a Home button (just a rectangle with assigned macro)

Sub Button_Home()
Sheets("HOME").Select
End Sub

But, strangely, if the view is set to Page Layout, when the rectangle is clicked Excel crashes.

Has anyone come across this before and have a solution?

Cheers,
Andrew

 

[RoryA]

Luckily no - I saw it in a forum post elsewhere. (I have never used Page Layout view for anything )