| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Apply a macro to all sheets - save me from hours and hours of work
Hello everyone, thank you for all your help! You guys are wonderful. I have
a new challange that I am faced with, a rather tedious one at that. I have a workbook that has 50+ worksheets. I need to change the print margins to 0 as well as the page orientation to portrait on every page. I can't program VBE but I recorded a macro that does what I need it to. I deleted all the stuff I didn't need and it works. However it only works on the worksheet that is open. What code do I add to make it cycle through every worksheet? I don't know how to program in VBE so please keep it simple. Thank you for your help in advance... I owe you guys a beer. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting work hours to day/hours/minutes | Excel Discussion (Misc queries) | |||
| Determining work hours between dates / hours | Excel Worksheet Functions | |||
| wages - multiply hours and minutes by number of hours worked | Excel Discussion (Misc queries) | |||
| Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
| HELP. Can this be done easily? Save me HOURS of work. | Excel Programming | |||
Threaded Mode
