View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Excel'ed Failures Excel'ed Failures is offline
external usenet poster
 
Posts: 2
Default 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.