View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Corey Corey is offline
external usenet poster
 
Posts: 276
Default sheet protection - only selected range to be able to select/input data

if i select an array/range of cells, i want only those cells to be able to
be selected and/or data input into them.
But i did not want a popup msg to ask for a password, just a "DISABLED"
msgbox.
I want to prevent formulas being deleted .
How can i do this ?

--
Regards

Corey