VBA Printing Code

A

AndreaF

New Member
Joined
Jun 16, 2015
Messages
1
I have a spreadsheet with 32 worksheets.

Sheet 1 and 2 will not need to be printed.


Sheets 3, 4, 5 will be printed with current print ranges set.


I need Sheets 6 through 32 printed only if the formula in cell B5 is greater than 0.


Can you help me with setting up a VBA code for this?


Thank you!
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
You must log in or register to reply here.

Similar threads

tlc53
  • Question
Don't print blank pages, where page breaks are contained between hidden rows
Replies
0
Views
48
tlc53
tlc53
Y
  • Solved
Greyed Rows - print BLACK
Replies
3
Views
134
rollis13
rollis13
N
  • Solved
Script to determine number of pages to save/print "Microsoft Print to PDF"
Replies
3
Views
164
noveske
N
Nuke_It_Newport
  • Question
Modify worksheets vs. create temporary worksheets for printing?
Replies
2
Views
107
Nuke_It_Newport
Nuke_It_Newport
I
  • Solved
VBA Loop: Enter Value in a Cell then Save a Subset of Sheets as pdf
Replies
2
Views
109
itord1973
I

Forum statistics

Threads
1,203,565
Messages
6,056,102
Members
444,846
Latest member
pbailey

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top