Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting sheets with drop down boxes
I have an excel spreadsheet that has drop down boxes and formulas. I want to
be able to protect this spreadsheet so that other user will not delete my formulas. I password protected the spreadsheet, however, when this sheet is protected i am not able to select from the drop down list. Is there a macro that I can incorporate into my worksheet that would help me with this problem. If so, can you please give me the codes needed? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting sheets with drop down boxes
Unlock the cells that have the data validation.
-- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Dolores Gomez" wrote: I have an excel spreadsheet that has drop down boxes and formulas. I want to be able to protect this spreadsheet so that other user will not delete my formulas. I password protected the spreadsheet, however, when this sheet is protected i am not able to select from the drop down list. Is there a macro that I can incorporate into my worksheet that would help me with this problem. If so, can you please give me the codes needed? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting sheets with drop down boxes
Hi Gary,
If I unlock the cells that have the validation (I also have a function in the same cell) there is a chance that they will delete the function and I only want them to have the option to click on the drop down box. "Gary Brown" wrote: Unlock the cells that have the data validation. -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Dolores Gomez" wrote: I have an excel spreadsheet that has drop down boxes and formulas. I want to be able to protect this spreadsheet so that other user will not delete my formulas. I password protected the spreadsheet, however, when this sheet is protected i am not able to select from the drop down list. Is there a macro that I can incorporate into my worksheet that would help me with this problem. If so, can you please give me the codes needed? Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting sheets with drop down boxes
OK, let's go back to basics. I need to understand how you got to where you
are. - Did you first enter formulas, then create Data Validation [DATA VALIDATION ALLOW LISTS SOURCE.... ] then protect your worksheet? - Does the formula you talk about reference the cells used in LISTS SOURCE ? -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Dolores Gomez" wrote: Hi Gary, If I unlock the cells that have the validation (I also have a function in the same cell) there is a chance that they will delete the function and I only want them to have the option to click on the drop down box. "Gary Brown" wrote: Unlock the cells that have the data validation. -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Dolores Gomez" wrote: I have an excel spreadsheet that has drop down boxes and formulas. I want to be able to protect this spreadsheet so that other user will not delete my formulas. I password protected the spreadsheet, however, when this sheet is protected i am not able to select from the drop down list. Is there a macro that I can incorporate into my worksheet that would help me with this problem. If so, can you please give me the codes needed? Thanks. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting sheets with drop down boxes
I have a sheet that has drop down boxes and functions associated to these
drop down boxes. one of the functions on these drop down boxes is the following: =IF($Q25="","",IF(INDIRECT("'UNIQUE ATTR'!"&ADDRESS(MATCH($Q25,PTLIST,FALSE)+'UNIQUE ATTR'!$M$1,MATCH(S$22,ATTR,FALSE)+'UNIQUE ATTR'!$M$2))="X","SELECT VALUE","")). the only reason I want to protect this worksheet in case someone selects from the drop down list and they decide to remove their choice (sometimes users will go in and pick the cell and click on delete). If they hit delete it will remove the if statement. I also tried going into the format and select "hide formula", however, this did not prevent me from deleting the function. "Gary Brown" wrote: OK, let's go back to basics. I need to understand how you got to where you are. - Did you first enter formulas, then create Data Validation [DATA VALIDATION ALLOW LISTS SOURCE.... ] then protect your worksheet? - Does the formula you talk about reference the cells used in LISTS SOURCE ? -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Dolores Gomez" wrote: Hi Gary, If I unlock the cells that have the validation (I also have a function in the same cell) there is a chance that they will delete the function and I only want them to have the option to click on the drop down box. "Gary Brown" wrote: Unlock the cells that have the data validation. -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Dolores Gomez" wrote: I have an excel spreadsheet that has drop down boxes and formulas. I want to be able to protect this spreadsheet so that other user will not delete my formulas. I password protected the spreadsheet, however, when this sheet is protected i am not able to select from the drop down list. Is there a macro that I can incorporate into my worksheet that would help me with this problem. If so, can you please give me the codes needed? Thanks. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting sheets with drop down boxes
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting sheets with drop down boxes
sent an 'answer' via email.
-- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Dolores Gomez" wrote: I have a sheet that has drop down boxes and functions associated to these drop down boxes. one of the functions on these drop down boxes is the following: =IF($Q25="","",IF(INDIRECT("'UNIQUE ATTR'!"&ADDRESS(MATCH($Q25,PTLIST,FALSE)+'UNIQUE ATTR'!$M$1,MATCH(S$22,ATTR,FALSE)+'UNIQUE ATTR'!$M$2))="X","SELECT VALUE","")). the only reason I want to protect this worksheet in case someone selects from the drop down list and they decide to remove their choice (sometimes users will go in and pick the cell and click on delete). If they hit delete it will remove the if statement. I also tried going into the format and select "hide formula", however, this did not prevent me from deleting the function. "Gary Brown" wrote: OK, let's go back to basics. I need to understand how you got to where you are. - Did you first enter formulas, then create Data Validation [DATA VALIDATION ALLOW LISTS SOURCE.... ] then protect your worksheet? - Does the formula you talk about reference the cells used in LISTS SOURCE ? -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Dolores Gomez" wrote: Hi Gary, If I unlock the cells that have the validation (I also have a function in the same cell) there is a chance that they will delete the function and I only want them to have the option to click on the drop down box. "Gary Brown" wrote: Unlock the cells that have the data validation. -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Dolores Gomez" wrote: I have an excel spreadsheet that has drop down boxes and formulas. I want to be able to protect this spreadsheet so that other user will not delete my formulas. I password protected the spreadsheet, however, when this sheet is protected i am not able to select from the drop down list. Is there a macro that I can incorporate into my worksheet that would help me with this problem. If so, can you please give me the codes needed? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protecting sheets with drop down boxes | Excel Worksheet Functions | |||
Drop down boxes/tick boxes | Excel Worksheet Functions | |||
combo boxes & protecting worksheets | Excel Worksheet Functions | |||
Protecting Check Boxes to prevent editing | Excel Discussion (Misc queries) | |||
Protecting Sheets | Excel Worksheet Functions |