Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel MAcro/Printing
I am working on a new project. I have 25 worksheets within the the workbook. Each is named differently. I would like to be able to create a macro which will determine how many pages to be printed for each worksheet, and for every new page within that worksheet, for it to copy from the first page cells A1:E6 (which contains the heading of the tables) and them those headings in cells A1:E6 of the following page, without deleting the information which begins on the new page. Also then insert page numbers on each page. Also how do I write a macro which will select all worksheets and password protect/unprotect multiple sheets at once. typing in a password for 25 or more individual sheets is a daunting task Can someone help me please. -- kwedde01 ------------------------------------------------------------------------ kwedde01's Profile: http://www.excelforum.com/member.php...o&userid=24156 View this thread: http://www.excelforum.com/showthread...hreadid=377858 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Macro for Excel 97 | Excel Discussion (Misc queries) | |||
Printing Problem In Excel Due to Macro? | Excel Discussion (Misc queries) | |||
Printing a word doc via macro/VBS/Excel | Excel Programming | |||
Help. Excel Printing Macro | Excel Programming | |||
Text printing from VBA Excel macro | Excel Programming |