Thread: How to stop info from being pasted into a cell that has a drop dow
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo[_2_] Sheeloo[_2_] is offline
external usenet poster
  
Posts: 364
Default How to stop info from being pasted into a cell that has a drop dow
Use Data Validation...

"lorettal" wrote:

I need to prevent someone from overwiting information in a cell that has a
drop down box of items to choose from by not allowing them to paste
information they copied from other spreadsheets.
Reply With QuoteReply With Quote