Vba: Set Print Format Across Multiple Sheets

  • Hi,
    I'm trying to write a macro to select all the Sheets in a Workbook, and set some properties [Auto ColumnWidths, Landscape, and Fit to 1 page wide] for all of them.

    I don't know the names of the sheets, nor how many there will be - this part is tagged on the end of a long macro that creates new files and pastes various data into them.

    The code below only seems to work on the Active sheet - not any of the others selected. Curiously, I can set a specific column width for all sheets, but not Auto Widths.

    Many thanks if anyone can help ... been at this for hours now, and not getting any nearer. I wouldn't mind, but I've done all the complex stuff!!

    Thanks & regards,

  • Re: Vba: Set Print Format Across Multiple Sheets


    Hope this helps....


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!