LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 389
Default Protect all cells but allow data validation dropdown change

I have a file that I want to protect all cells. But at the same time there
are certain cells that have a Data Validation Dropdown where I want the user
to be able to select an item off the dropdown list and update the cell. I
want to protect everything because I do not want anyone to be able to "Paste"
anything in the file or make any changes in the file except for making
selections from the Data Validation Dropdown and no other way.

For example: The cells that have dropdowns must be in protected mode when
user enters the cell because I do not want the user to be able to take a cell
from somewhere else and copy / paste over the Data Validation Cell I have
setup. Therefore I need the protection as mentioned above.

How can I accomplish this?
Thank you for your help.

Steven
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data validation with dropdown list geotso Excel Discussion (Misc queries) 2 February 1st 09 05:59 PM
Dropdown lists from datavalidation. MichaelZ Excel Discussion (Misc queries) 3 October 21st 08 02:31 PM
Protect Data validation cells from copy paste Guneet Ahuja Excel Discussion (Misc queries) 3 May 21st 08 04:07 PM
Data Validation Dropdown bug Charlie Excel Programming 0 February 20th 08 03:01 PM
Data Validation Calender Dropdown andyp161[_3_] Excel Programming 1 September 7th 04 10:14 PM


All times are GMT +1. The time now is 05:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"