View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Les[_8_] Les[_8_] is offline
external usenet poster
 
Posts: 19
Default Add a comment on cell content change with VBA

Hello all, i have a spreadsheet that is protected and shared. When the
user logs in it "unlocks" a certain range of cells for him to update.
I would like to insert a comment when he/she updates the cell, but the
worksheet "Change" function does not work if it is shared & protected.
Is there a way around this ??