+ Reply to Thread
Results 1 to 6 of 6

Protect Sheet Allowing Users to Format Rows/Edit Objects?

  1. #1
    Registered User
    Join Date
    11-15-2009
    Location
    Palmer, Alaska
    MS-Off Ver
    Excel 2010
    Posts
    69

    Unhappy Protect Sheet Allowing Users to Format Rows/Edit Objects?

    I want my macro to protect my sheet again after it is done to allow editing objects and formatting rows. I am really stuck and have come up with the below, but it isn't working. Please help!


    Please Login or Register  to view this content.
    Last edited by Kristine T.; 11-16-2009 at 03:17 PM.

  2. #2
    Registered User
    Join Date
    11-15-2009
    Location
    Palmer, Alaska
    MS-Off Ver
    Excel 2010
    Posts
    69

    Re: Protect Sheet Allowing Users to Format Rows/Edit Objects?

    Okay, I made this work. However, when I put in AllowEditingObjects or AllowEdit Objects it doesn't work. Does anyone know how I should write that last bit so it works?

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    11-15-2009
    Location
    Palmer, Alaska
    MS-Off Ver
    Excel 2010
    Posts
    69

    Re: Protect Sheet Allowing Users to Format Rows/Edit Objects?

    Okay, I found the below, but I don't know how to encorporate it in my WorkbookAfterPrint (). I have both posted below. My sheet is named "TA Form", so I assume the With Sheet1 should be changed to With Sheets ("TA Form")?

    Please Login or Register  to view this content.


    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    11-15-2009
    Location
    Palmer, Alaska
    MS-Off Ver
    Excel 2010
    Posts
    69

    Talking Re: Protect Sheet Allowing Users to Format Rows/Edit Objects?

    I solved it. Here is the answer....


    Please Login or Register  to view this content.

  5. #5
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Protect Sheet Allowing Users to Format Rows/Edit Objects?

    Thank you for posting your solution.

    If interested you can format all ranges simultaneously:

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    11-15-2009
    Location
    Palmer, Alaska
    MS-Off Ver
    Excel 2010
    Posts
    69

    Re: Protect Sheet Allowing Users to Format Rows/Edit Objects?

    I was wondering about that... thanks!!!

+ 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