3 Replies Latest reply: Jan 4, 2018 10:00 AM by Cassandra Baqir RSS

    Macro for NP Format Cleanup

    Cassandra Baqir

      Hi everyone,

       

      Since NP doesn't support merging cells in Excel, I believe I need to use a macro to clean up formatting issues. I've never done this before but a quick Google search leads me to believe it's possible to do a Merge Across on EACH sheet in the workbook (except the first). A couple of questions since I have never done this if you will...

       

      1. How do I get the macro to auto-run on every sheet other than the first? I don't want the end user to have to do anything.
      2. I believe it will not run via the NP output but only once the user opens the file, correct?

      1-3-2018 8-55-02 AM.jpg