View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default How to restrict printing certain sheets

Kassie wrote...
set the print area to one cell, eg A1, then protect the sheet. *Of course,
you would need a macro to do not only this, but also to reset the print range
when you do want to print, and again set it to A1, after printing. *
Alternatively, use a macro to set the visibility of the sheet to
XLVeryHidden, which means it is not visible, cannot be unhidden, except with
code, and can therefore not be printed.


Subject to the caveats that users can always disable macros in any
particular workbook, internal password protection is easily overcome,
and macros in OTHER workbooks can operate on workbooks opened with
their own macros disabled. IOW, no robust way to prevent moderately
sophisticated users from obtaining access to EVERYTHING in any
workbook they can open.