+ Reply to Thread
Results 1 to 3 of 3

macro code for protected and shared worksheet

  1. #1
    Registered User
    Join Date
    09-28-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    2

    macro code for protected and shared worksheet

    I have a protected and shared worksheet sheet with 3 user access, 2 users has their own password to work in their selected ranges and one user range is without password, reset of the sheet is protected for all.
    I am using macro for timestamp, but when macro unprotect the sheet, it goes open for other user too and also when macro protect the sheet Allow user to edit the range doesn’t apply.
    I just copied the code coz I don’t know vba, below is the code anyone please help me to resolve this issue.

    Please Login or Register  to view this content.

    Moderator Note
    :

    Pls add code tags around your code as per forum rule#3.
    Last edited by afbillah; 09-29-2013 at 03:36 PM. Reason: add code tag

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: macro code for protected and shared worksheet

    I could be wrong, but I beleive Macros will not work on a shared workbook.

  3. #3
    Registered User
    Join Date
    09-28-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: macro code for protected and shared worksheet

    Hi thanks but is there any option to creat 3 timestamp for 3 different protected range of a protected sheet and shared workbook recmondad with macro as I try it using IF but it make sheet work too slow

+ 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. VBA code to open protected shared file
    By Deredrum in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-05-2013, 09:29 AM
  2. Auto insert row in protected worksheet in shared workbook
    By DavidBW in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-20-2011, 06:03 AM
  3. Sorting a protected shared worksheet
    By Nigel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-25-2009, 05:55 AM
  4. Sorting protected shared worksheet
    By Nigel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-29-2008, 11:27 AM
  5. Writing cells on a protected worksheet in a shared workbook
    By Weebie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-18-2007, 08:16 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