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

 

[Michael M]

Hi Andrew and welcome to the Board..
Do you mean Page Break view ??
Seems a bit odd, it should work fine in any view.
Are there any other macros in the workbook.
you could of course add Normal view to the macro, but it shouldn't need that !!

Sub Button_Home()
ActiveWindow.View = xlNormalView
Sheets("HOME").Select
End Sub

 

[Fazza]

An application I've written errored due to being in the page layout view. The error was when I tried to read data via ADO from the closed file. In my application the error disappeared by adding a line like Michael has already posted. This was a couple of years ago, btw, and no problems since.

ActiveWindow.View = xlNormalView

 

[AndrewWalker]

Hi Michael,

Thanks, and thanks for the response.

The excel mouseover calls it page layout view. I did try adding the line you proposed to the macro, but the problem remains. I don't see how the starting view makes a difference but it's fatal!

There are several macros in the file, but none of the others are on the worksheet in question. Im at a bit of a loss.

Perhaps I've created an instability in the whole file somehow?

Cheers,
Andrew

Hi Andrew and welcome to the Board..
Do you mean Page Break view ??
Seems a bit odd, it should work fine in any view.
Are there any other macros in the workbook.
you could of course add Normal view to the macro, but it shouldn't need that !!

Sub Button_Home()
ActiveWindow.View = xlNormalView
Sheets("HOME").Select
End Sub

 

[RoryA]

Try putting the buttons on the first page of the sheet if they aren't already.

 

[AndrewWalker]

Rory, you are a genius! That fixes it outright. Why in the world does that make a difference, do you know?

Try putting the buttons on the first page of the sheet if they aren't already.

 

[taurean]

If you are using "Shapes" then you can use hyperlink as in Right Click | Hyperlink | Place in this document and select Home sheet. You wouldn't need macro then!

 

[RoryA]

Rory, you are a genius! That fixes it outright. Why in the world does that make a difference, do you know?

I think it's a bug - shouldn't make any difference at all in my opinion, but it does.

 

[AndrewWalker]

Haha, good point taurean! I was writing a few macros for the file, so I was in the macro zone. The other simple solution was to keep the sheet in normal view. I was just intrigued by the problem!

If you are using "Shapes" then you can use hyperlink as in Right Click | Hyperlink | Place in this document and select Home sheet. You wouldn't need macro then!

 

[Michael M]

Hi Rory, that's a great pickup.....I'm guessing you found that out, the hard way........