Excel Macro Help/Printing Files
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.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL