Margins and Landscape

[hviking]

I've got a slight problem. I've got close to 200 worksheets that needs to have the margins changed, and the page orientation changed to landscape. Is there a quick macro that someone could write that could do this, or a quick way of doing it without having to go to each tab and each file one at a time?

Thanks

 

[Brian from Maui]

On 2002-04-16 10:53, hviking wrote:
I've got a slight problem. I've got close to 200 worksheets that needs to have the margins changed, and the page orientation changed to landscape. Is there a quick macro that someone could write that could do this, or a quick way of doing it without having to go to each tab and each file one at a time?

Click on the first worksheet and hold down the shift key and click on the last worksheet. Go to File/Page setup

Thanks

 

[hviking]

Thanks a million.

So simple I should have know about it.

Thanks again;