Hiding columns for printing

  • Thread starter Thread starter Scotty
  • Start date Start date
S

Scotty

Is there a way to have columns showing on screen (and
allowing data input) but be hidden when printing without
using hide and unhide every time?

Thanks
 
Is below a macro that you are suggesting I write?
-----Original Message-----
try
columns(3).hidden=true
activesheet.printout
columns(3).hidden=false

--
Don Guillett
SalesAid Software
(e-mail address removed)



.
Click to expand...
 
yes
sub hidecolbeforeprint
columns(3).hidden=true
activesheet.printout
columns(3).hidden=false
end sub
 
You could create a Custom View for each area that you want to print:

1. Set the print area for the first selection that you want to print
2. Choose View>Custom Views
3. Click the Add button.
4. Type a name for the view, e.g. Sheet1View1
5. Leave the checkmarks for Print Settings, and Hidden Rows
6. Click OK

After the views are created, use the Report Manager to automate the
printing process. (The Report Manager is an Add-In that you may have to
install. If it doesn't appear on the View Menu, choose Tools>Add-ins.
Select Report Manager, and click OK)

1. Choose View>Report Manager
2. Type a name for the Report
3. Select the sheet that contains the first view you want to print.
4. Select the View, click Add
5. Repeat steps 3 and 4 to add all the Custom views.
6. Click OK

To print a report, choose View>Report Manager
Select a report, click Print
 
Back
Top