Print visible sheets excluding certain ones

**amelio** · 03-09-2011, 11:05 AM

I have the following macro and would like to add some addtional sheets into the macro so they are also omitted from printing.

Please Login or Register  to view this content.

I struggling to make the macro work when I add "sheet2" "sheet3" etc on top of "sheet1".

Thanks
Ben

**JBeaucaire** · 03-09-2011, 11:31 AM

Why is it a struggle? You already see the syntax for testing sheet names and you see the syntax for using AND to add tests. Keep doing that.

Please Login or Register  to view this content.

**amelio** · 03-09-2011, 11:39 AM

Thanks. I was being a right donut with this.

**JBeaucaire** · 03-09-2011, 12:17 PM

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

Re: Print visible sheets excluding certain ones