View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
TomHinkle TomHinkle is offline
external usenet poster
 
Posts: 36
Default Stop user selecting more than one sheet at once?

why don't you just protect the cells/worksheets you don't want overwritten??
(tools-protection)

"RobW" wrote:

Hi,
Help would be apprecitaed:
Within a given workbook i wish to stop users selecting more than one sheet
at once. (To make sure data is not overwritten in both sheets as these cells
are llinked and would be very hard to undo)
Thanks in advance,
Rob