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,
    Dave

  • Re: Vba: Set Print Format Across Multiple Sheets


    Hi,


    Hope this helps....


    Jon


Participate now!

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