Code to Print Entire Workbook Except for One Sheet

  • Thread starter Thread starter DoctorV
  • Start date Start date
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
 
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
 
Back
Top