Hi Steve
For now I have dispensed with trying to resize the rows by macro and sized them to allow what should be sufficient text in each box.
All blue cells are locked to stop users modifying them.
The Handover Sheet at the end of the Workbook will update and resize all rows as soon as you click on any cell on the table. You can then print this sheet as normal. Don't worry about the blue selection, when you print it will print correctly.
The workbook can be set to view Full Screen on each page so you dont see all the toollbars, you can cancel this by selecting the close full screen button top left hand corner of the screen.
Another way of moving to another worksheet if you cannot see all the table is to right-click on one of the arrows at the bottom left hand corner of your worksheet screen. This will bring up a dialogue box where you can select which worksheet you wish to view.
The workbook needs a thorough test before use but let me know what you think and if you need anything else then get back to me.
Good luck.
Tony(OTPM)
|