This macro can be used to correct any pagination problems within Microsoft Excel files exported from the CADS RC schedule.
This macro works for both Microsoft Office Excel 2003 and 2007.
Steps to install and run this macro:
To install:
- Ensure Microsoft Excel is closed
- Copy the PrintPageSetup.XLS macro to the Microsoft Excel start-up folder.
e.g. C:\Documents and Settings\%USERNAME$\Application Data\Microsoft\Excel\XLSTART\
To run:
- Open the Excel (XLS) file that you wish to tidy
- Press CTRL+SHIFT+A keys simultaneously to start the macro
- A Page Setup dialog will appear requesting selection of the last piece of text on the first schedule page
- Pressing OK will then mean that all pages are adjusted so that they can be printed appropriately
Should you need more assistance with this macro then please don't hesitate to contact
|