Code to Print Entire Workbook Except for One Sheet

D

DoctorV

I wanted to know what would be the VBA Code I could put behind a butto
to Print All Worksheets in a workbook EXCEPT for the sheet name
MainForm?
Thank
 
F

Frank Kabel

Hi
try something like
sub print_it
dim wks as worksheet
for each wks in activeworkbook.worksheets
if lcase(wks.name)<>"your_sheet" then
wks.printout
end if
next
end sub
 
Top