View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Silena K-K Silena K-K is offline
external usenet poster
 
Posts: 37
Default Stop Overwriting (Fill, Copy, etc) Data Validation

Hi Everyone

How do I stop a user overwriting Data Validation rules with the Fill (down,
right, etc) command?

I have a macro set-up to prevent users from Cut/Copy/Paste and Cell Drag and
Drop but don't know what the code is for Fill.

Thank you, Silena