Consulting

Results 1 to 2 of 2

Thread: Solved: Macro to unprotect and protect in shared workbook

  1. #1
    VBAX Regular belly0fdesir's Avatar
    Joined
    Jan 2006
    Location
    Inland Empire
    Posts
    36
    Location

    Solved: Macro to unprotect and protect in shared workbook

    This site has been so helpful to me and I am extremely thankful for that. I have another question.

    This question has been x-posted here.

    I have a macro that needs my sheets to unprotect to run, so I have it unprotect, then do it's thing, then protect the sheets again. However, I need my workbook to be shared and I cannot unprotect my shared workbook. The macros just won't work if the workbook is shared. Does anyone know a way around this?

  2. #2
    VBAX Regular belly0fdesir's Avatar
    Joined
    Jan 2006
    Location
    Inland Empire
    Posts
    36
    Location
    I've marked this topic solved because I realize there is no way around this. I will simply accomodate the obstacle by leaving the workbook unshared and allowing only 1 user to make changes at a time. Thank you for you time.

Posting Permissions

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