Page Setup grayed out in Print Preview

Hi

My code will bring a the relevant area of a specific sheet up as a print preview which allows the user the options of printing or cancelling the print preview. I'd like there to be the option of setting the page up better before printing, but the "Page Setup" button is grayed out.

Any ideas how I can ensure the Page Setup is available to use please?

This is my code

Please Login or Register  to view this content.

Many thanks

Frankie

Go it!

Added .PrintPreview EnableChanges:=True to the code.

Well!

Please Login or Register  to view this content.

doesn't want to work! SO Frustrating!!!

Any ideas why the Page Setup isn't usable in Print Preview?? (see attached picture)

Frankie

Attach the workbook for someone to explore it.

Artik