VBA set page format and save with notifications off

  • I've put toghether some code to open an excel file and change for format (page setup and set columns to autofit) and then save the file. It works except that I want it to work invisisibly.


    If I set notifications to true and save it with a prompt the formatting changes are saved as I want. If I set notifications to false the changes aren't saved.


    I haven't experimented with application visible true or false.


    Is there a way to have it save the changes without going through the prompt.


    The code is below:




    Thanks for any help!

Participate now!

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