+ Reply to Thread
Results 1 to 2 of 2

Changing Locked property of cells in Protected sheet with option UserInterfaceOnly=True

  1. #1
    Registered User
    Join Date
    10-27-2014
    Location
    UK
    MS-Off Ver
    Office 10
    Posts
    25

    Changing Locked property of cells in Protected sheet with option UserInterfaceOnly=True

    When protected with the UserInterfaceOption = True, I can clearly make some types of changes to even 'Locked' cells using vba.

    But I don't seem to be able to use vba to change the 'Locked' property of 'locked' cells without actively Unprotecting the worksheet. Is that right?

    Thanks for your help in clarifying this for me. :-)

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Changing Locked property of cells in Protected sheet with option UserInterfaceOnly=Tru

    You should be able to change the Locked property. Although UIO is not 100% reliable in my experience, it should work for that.
    Remember what the dormouse said
    Feed your head

+ 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. [SOLVED] Changing locked cells and colors on a protected sheet
    By DENWARD in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-04-2014, 11:49 AM
  2. [SOLVED] AllowFormattingCells not working on Protected sheet with UserInterfaceOnly
    By KL591 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-05-2012, 10:07 AM
  3. Macro doesn't work on UserInterfaceOnly-protected sheet
    By Kasama in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-08-2006, 05:25 AM
  4. Strange problems with setting hidden property of a range when sheet protected with UserInterfaceOnly
    By heikki.vuolteenaho@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-06-2006, 11:20 AM
  5. not all cells are locked when protect is true for work sheet
    By Alexandre Brisebois (www.pointnetsolutions.com) in forum Excel General
    Replies: 3
    Last Post: 07-28-2005, 07:05 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