+ Reply to Thread
Results 1 to 2 of 2

Codes to allow or not all users when protecting sheet

  1. #1
    Registered User
    Join Date
    03-06-2012
    Location
    west coast Norway
    MS-Off Ver
    Office 365
    Posts
    55

    Codes to allow or not all users when protecting sheet

    All,

    I have many sheets that i would like to allow users different access.

    So, does anyone have the codes for all the options when protecting a sheet and choosing weather or not to "Allow all users of this workbook to:" (and then all the options are listed...)

    I would need these codes as when running macros i need to unprotect the sheet, and i then need to set the criteria again when protecting at end...

    All help is appreciated
    kind regards
    tigergutt

  2. #2
    Registered User
    Join Date
    03-06-2012
    Location
    west coast Norway
    MS-Off Ver
    Office 365
    Posts
    55

    Re: Codes to allow or not all users when protecting sheet

    bumping this up. If the explanation is bad or unclear, i can try and rewrite...

+ 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. Replies: 12
    Last Post: 10-16-2014, 09:02 AM
  2. Protecting Macro codes (Invisible to everyone)
    By Logan CMA in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2013, 05:53 PM
  3. [SOLVED] VBA code to "allow all the users to" when protecting a sheet
    By mrjinx007 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-19-2012, 01:36 PM
  4. Protecting data for certain users only?
    By Kim_J in forum Excel General
    Replies: 0
    Last Post: 07-01-2008, 12:41 PM
  5. hiding macro codes upon protecting the worksheet
    By eehj23 in forum Excel General
    Replies: 1
    Last Post: 04-27-2006, 11:00 PM
  6. Protecting cells for different users
    By AndyOne in forum Excel General
    Replies: 3
    Last Post: 07-08-2005, 04:05 PM
  7. Protecting VBA macro from modification by users
    By cason621 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-18-2005, 03:06 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