excel vba code - Allow user to change validation [TRUE/FALSE] even though it is protected

**shannen** · 09-01-2013, 10:49 PM

I have a problem how I can allow my user to change the TRUE or FALSE validation even though it is protected.

Is there any possible other solution about this problem.

Simple explanation:

User
*ALLOW:
Change the cell value TRUE / FALSE validation ONLY

*NOT ALLOW:
Cannot change ANYTHING except [ALLOW]

Attachment below:

SampleSheet.xlsb

**mahaveersomani** · 09-02-2013, 12:43 AM

FIRST Unprotect your protected sheet..
then use allow user to Edit range option in review tab...
then protect your sheet again.

i hope it works for you...

If it was really helpful to you then dont forget to hit * button for user reputation.

REgards
CA Mahaveer Somani
9785216211

**shannen** · 09-02-2013, 04:04 AM

I still don't know how to do it

excel vba code - Allow user to change validation [TRUE/FALSE] even though it is protected

LinkBack

Thread Tools

Rate This Thread

Display

excel vba code - Allow user to change validation [TRUE/FALSE] even though it is protected

Re: excel vba code - Allow user to change validation [TRUE/FALSE] even though it is protec

Re: excel vba code - Allow user to change validation [TRUE/FALSE] even though it is protec

Thread Information

Users Browsing this Thread

Similar Threads

Excel VBA Code to make all my Toggle Buttons Red if False and Green if True, easier way.

Data validation list not allowing user to change value from drop down when sheet protected

Macro to change name value from true to false

Data validation: If previous column is having a value, then return FALSE else TRUE

Use IF to change value in a different cell when TRUE (or FALSE)?

Bookmarks

Bookmarks

Posting Permissions