Can anyone please help. I have a 10 sheet workbook that I would like to include a macro on each sheet to print the active sheet the number that I type into a cell. For example:- The cell above could have print number and if I type 5 then 5 sheets would print without having to go to file,print and type the number required. Then if I go to the next sheet I might need 15 printed. Is this possible because when I try to record a macro, the print buttons ect are greyed out. Any help would be thankfully received.
Apachewar
Bookmarks