+ Reply to Thread
Results 1 to 2 of 2

Need to restrict Saving & Printing a spreadsheet

  1. #1
    Registered User
    Join Date
    05-02-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Need to restrict Saving & Printing a spreadsheet

    Hi everyone,

    While my request may seem repetitive, I have a certain need that I hope some of the experts here can help me with.

    I need to restrict printing & saving functionality on a excel spreadsheet that is shared with a large group of people.

    I was also hoping for the restricting save part, to do an AD lookup to see if they are a member of group "X", if they are then allow the save, if they are not then deny the save.

    Any help provided is greatly appreciated.

    Thanks,
    shaung411

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    6,273

    Re: Need to restrict Saving & Printing a spreadsheet

    Put code like this into the ThisWorkbook's codemodule:
    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to restrict view for users of a spreadsheet
    By Ian M in forum Excel General
    Replies: 9
    Last Post: 02-09-2014, 08:38 AM
  2. Restrict Writing Access To Excel Spreadsheet
    By saucey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2012, 04:09 AM
  3. Restrict printing on certain worktabs
    By guerillaexcel in forum Excel General
    Replies: 1
    Last Post: 10-15-2010, 09:31 AM
  4. Restrict printing unless certain cells are completed
    By m0llydog in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2007, 08:01 AM
  5. Replies: 0
    Last Post: 06-21-2006, 02:50 PM

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