Formatting Sheets in a workbook

[garymu16]

Hi All,

Is there a way to format all sheets in a workbook to be the same. I find myself having to go into page set-up change from portrait to landscape, change my margins etc. in a workbook I produce weekly.

I was wondering if there is a way to set-up all sheets on a workbook to my predetermined defaults?

Thx

Gary

 

[dave3009]

One option for you

Run the Macro Recorder whilst you set up your initial page, then run it on all subsequent pages.

HTH


Dave

 

[VoG]

Or another option is to do that then post the recorded code here. We can tidy-up the code and modify it so it automatically loops through each sheet in the workbook.