+ Reply to Thread
Results 1 to 2 of 2

Protecting print area?

  1. #1
    Sabrina D
    Guest

    Protecting print area?

    Is it possible to lock the print area somehow in an Excel document?

    Thanks




  2. #2
    Debra Dalgleish
    Guest

    Re: Protecting print area?

    I don't know of any way to lock the print area. You could add code to
    the workbook's BeforePrint event, and set the print area there.

    However, if users don't enable macros, the print area won't be set.

    For instructions on storing and using macros, you can read David
    McRitchie's notes:
    http://www.mvps.org/dmcritchie/excel/getstarted.htm


    Sabrina D wrote:
    > Is it possible to lock the print area somehow in an Excel document?


    --
    Debra Dalgleish
    Excel FAQ, Tips & Book List
    http://www.contextures.com/tiptech.html


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1