View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Valeria Valeria is offline
external usenet poster
 
Posts: 127
Default change cells when a particular user makes her input

Dear experts,
we have a spreadsheet with sales forecasts and an OP who is entering the
real sales data month by month when available. I would like to be able to
make a difference between the forecast months and the real figures, possibly
with different cell colours and by protecting the real figures; to do so, I
would like Excel to recognize that the data in cell is entered by a
particular user - the OP - and therefore change format and protect the cells.

Is this possible with VBA programming?
Thank you!
Best regards
--
Valeria