+ Reply to Thread
Results 1 to 4 of 4

Form protection keeps changing

  1. #1
    Registered User
    Join Date
    08-27-2013
    Location
    Kent
    MS-Off Ver
    Excel 2010
    Posts
    3

    Form protection keeps changing

    Hi, does anyone know how to force excel to remember the settings you select ffor worksheet protection. I need it to allow and remember the right to format cells AND Edit Objects everytime the protection is applied. I have some vba which unlocks all of my worksheets and then relocks all of them. This works just fine, but when the protection is reapplied the Format cells AND edit Objects options are not included.

    Code in use is:

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Last edited by arlu1201; 08-27-2013 at 10:01 AM. Reason: Use code tags in future.

  2. #2
    Valued Forum Contributor Miraun's Avatar
    Join Date
    04-03-2009
    Location
    New England
    MS-Off Ver
    2003, 2007, 2010, 2013
    Posts
    554

    Re: Form protection keeps changing

    Hi Strop;

    You need to add the additional criteria in there when you're declaring your protect.

    Please Login or Register  to view this content.
    Those were the three variables I got when I allowed edit objects and format cells. Hope that helps!
    Going for Guru! Click the Star to the bottom left of this post if I helped!

  3. #3
    Registered User
    Join Date
    08-27-2013
    Location
    Kent
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Form protection keeps changing

    Thanks Miraun,

    Sorry to appear stupid, but I am very new to vba. Where exactly do you mean this line should be inserted?

    regards

    Strop
    Last edited by Strop; 08-27-2013 at 10:20 AM. Reason: Spelling errors

  4. #4
    Registered User
    Join Date
    08-27-2013
    Location
    Kent
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Form protection keeps changing

    Thank you Miraun,

    After a second look it was obvious where it was supposed to go. This has worked, and will save me a great deal of time as I negotiate my way through all of the sheets in my workbook.

    Once again

    My Thanks

+ 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. Protection on a form
    By LilBee in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-28-2012, 03:03 AM
  2. Changing sheet protection
    By Niddeh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-19-2007, 06:34 AM
  3. Changing Colours With Protection
    By xander1987 in forum Excel General
    Replies: 3
    Last Post: 09-20-2005, 01:05 PM
  4. form size and protection
    By Liedson31 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-22-2005, 07:05 AM

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