Change Page Layout 1

[JasGrand]

Hello, I was wondering how I can change a sheet's page layout through vba in excel?

Thanks,


Jason Grandmaison

 

[SkipVought]

Hi,

1) Turn on the macro recorder.

2) make the page layout changes you want.

3) turn off the macro recorder.

4) observe the recorded code.

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}

 

[JasGrand]

ok, that's amazing... all this time i've been coding the long way (researching...)... lol...

Thanks,


Jason Grandmaison

 

[SkipVought]

FYI,

As a perceived "Expert", I often employ the macro recorder for processes and objects that I don't often use and even with some that I use alot.

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}