Excel display ruler question

[Pinaceous]

Hi All,

I'm using Excel's display option in using its ruler feature.

My question is, how do I lock the (columns/resize the columns) ie. Columns A:T to remain on one page?

I've noticed that when I log onto several different computers with its own printer the columns sometimes drift, which expands the (printed page/page layout).

Any suggestions in vba on how I can accomplish this?

Thanks,
Pinaceous

 

[shg]

Page Layout > Page Setup, Page, Fit to 1 page(s) wide

 

[Pinaceous]

Page Layout > Page Setup, Page, Fit to 1 page(s) wide

Thank you shg!

But now how do I describe this action with vba ?

 

[shg]

Record a macro?

 

[Pinaceous]

All right I guess if that is the only way.

I've closed my ribbon, so I thought there might be a code in lieu of.

I'll record one then see if it works on with my ribbon.

Thank again!

Paul

 

[shg]

It's not the only way, it's just a way to learn the object model.

 

[Pinaceous]

Hi shg,

It worked. I had to change my sequence around and show the headers for it to work but it did finally.

Thanks again!
Paul