LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Protect validation but allow drop down selection

Hi
I would like to allow users of my spreadsheet to select from a drop down
list in cells but would like to prevent changes to the validation settings
for the cell.

I am finding that people copypaste and the validation settings for the
copied cells are added to the pasted cell.

Any help?

Cheers

 
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 Update Validation Selection PCreighton Excel Worksheet Functions 3 September 11th 07 03:32 PM
Create new drop down from previous drop down selection Supe Excel Discussion (Misc queries) 3 January 19th 07 10:26 PM
protect cells after listbox selection Chay Excel Discussion (Misc queries) 0 November 30th 06 06:49 PM
drop down selection determines other drop down content lskelton Excel Discussion (Misc queries) 1 November 1st 05 11:14 PM
How can you jump to a selection in a validation drop-down? javervoo Excel Worksheet Functions 1 July 13th 05 06:08 PM


All times are GMT +1. The time now is 07:15 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"