Posts by royUK

    Done some more experimenting and this works


    I've edited the code slightly


    Try this. I've left all the options that you can change in the PageSetup for reference. I haven't checked it so let me know if it needs any amendments


    If you want to adjust multiple sheets within each workbook use


    Code
    1. Sheets.Select
    2. Selection.ColumnWidth = 10



    Try this. The code assumes each workbook has one sheet.


    This will add a unique identifier based on the time it is saved. Note that you must reset DisplayAlerts as well


    It would help to see your file