Macro no longer working?

Hello Everyone,

The below macro was working with no problem at all but for some reason no longer works?
Nothing has changed and I am now wondering if there is a more reliable way of writing this macro?

The only thing that I can think that has changed is that the date has changed from one month to the next?
This seems a bit odd but I really cannot think of what else could have caused this to change?

Sub PrintPageSix()
ActiveWindow.SelectedSheets.PrintOut From:=11, To:=11, Copies:=1, Collate _
:=True
End Sub

Thank you very much for any help.

Margate

When you say no longer works, do you get an error message? What is it?

Daft question - do you still have 11 pages in the worksheet?

Can you upload an example workbook?

Hello yudlugar,

After around 2 hours of trying to work out why the Macro has stopped working and pulling my hair out with frustration I turned away from the code and looked at the layout. It appears that someone has changed the page break's. Only leaving page # 10 as the actual page break. All other buttons did not work because they were not for page 10! Therefore when a button containing a macro for anything other than page 10 was pressed nothing would happen! Just as well I am patient with my staff! It turns out the button did not work because the printer had run out of paper. The staff thought it was the spreadsheet and messed with the page breaks when trying to fix it. They did not tell me that bit.....

I will mark this tread as solved. Hopefully it may help someone else some day wasting the 2 hours I wasted not realizing that page breaks are still changeable even when the sheet is locked!

Thank you very much for your willingness to help me,

Margate.