Printing a hidden sheet in excel

R

Ron Weaver

I AM USING THE FORM TOOLS TO CREATE A PRINT DIALOG BOX. IN
THIS BOX I AM HOPING TO PRINT SHEETS IN THIS WORKBOOK. THE
CATCH IS, I WANT TO HIDE THE SHEETS. IS THERE ANY WAY TO
DO THIS? I AM USING OFFICE XP EXCEL.
RON
 
S

spence

my guess is that you do not want the sheets visible at
all, even while they are printing. the only way is to
unhide the sheet, print it, and then hiding it again.
try this:

sub PrintHiddenSheet
ScreenUpdating = False
Sheets("Sheet1").Visible = True
Sheets("Sheet1").PrintOut
Sheets("Sheet1").Visible = xlVeryHidden
ScreenUpdating = True
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print order of TriFold - Publisher 365 0
Page numbering with Merged Document and IF statements 1
Table of content - format does not get saved 2
Shift Collate sheet 1-20 when printing entire workbook? 0
macOS Office365 Word 0
Duplicate Mail Merge Record Every Time 5
Hide columns based on row values 2
Publisher is filling blank lines with data 2

Top