VBA to force workbook to open in Page Layout mode

[Richard Wilkinson]

Hi everyone.

I'm working on a new set of Excel order forms at work and have been asked if it's possible to add some VBA to automatically force the workbook to open in Page Layout view?

We have a title, version number and company logo in the header and several colleagues have opened the file in Page Break layout - which doesn't show this logo etc.

If it's possible to make the XLSX file automatically load up in Page Layout view that would be great.

Thanks
Rich

[ByteMarks]

How about

Please Login or Register  to view this content.