Switch between two states

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

The blank ranges on a worksheet should be hidden out before the worksheet is
printed. It is easy to do it, but after printing, the worksheet shoul
restore to its original state before printed. Is there an easy way to do it
in Excel?

Clara
 
Hi
If rows and columns have been hidden try

Sub tester()
ActiveSheet.Columns.Hidden = False
ActiveSheet.Rows.Hidden = False
End Sub

regrads
Paul
 

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

How to check a printer's availability 4
Word document reporting 3
Overriding the calculation state 6
Print entire workbook with each sheet starting at page 1 8
Need Macro... 8
how to creat shortcut button to switching between worksheets? 1
HPageBreak not working 4
Print to PDF 2

Back
Top