locked
Excel Printing RRS feed

  • Question

  • Is there a way to keep users from printing an excel workbook.
    Monday, June 14, 2010 3:41 PM

Answers

  • Int the 'ThisWiorkbook module, put...

    Private Sub Workbook_BeforePrint(Cancel As Boolean)
      Cancel = True
    End Sub

    Hope this Helps,
    Gary Brown


    Gary Brown
    Monday, June 14, 2010 5:40 PM

All replies

  • Int the 'ThisWiorkbook module, put...

    Private Sub Workbook_BeforePrint(Cancel As Boolean)
      Cancel = True
    End Sub

    Hope this Helps,
    Gary Brown


    Gary Brown
    Monday, June 14, 2010 5:40 PM
  • You could stop printing with an event macro, but macros and events can be
    disabled.

    So the answer is not really.

    dmg7399 wrote:


    Is there a way to keep users from printing an excel workbook.

    --

    Dave Peterson

    Monday, June 14, 2010 7:10 PM