+ Reply to Thread
Results 1 to 1 of 1

Changing cell validation on a protected sheet

  1. #1
    Registered User
    Join Date
    04-18-2006
    Posts
    24

    Changing cell validation on a protected sheet

    I am trying to modify a cell's validation programatically on a protected sheet. Normally, this does not work since the interface and macros are both protected. A supposed solution is to use the worksheet.protect method on the sheet, and set the userinterfaceonly parameter to true.

    This didn't work for me, so after some more inquiry, I found that I should also set the DrawingObjects parameter to False when protecting, since the drop-down menus used in validation are affected by this.

    That sort of worked. The sheet was in a protected state and the macro successfully modified the validation as intended. BUT, despite being protected, locked cells can still be changed in the worksheet. So, it's not really protected.

    I've attached a sample workbook. Any insight would be greatly appreciated.
    Attached Files Attached Files

+ 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