View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Wayne Wayne is offline
external usenet poster
 
Posts: 133
Default 'Cell is protected' after VBA runs

D'oh!

I found the problem, sorry. The user had "Edit directly in cell" enabled in
their Options. As my code was before_DoubleClick, Excel was trying to allow
editing in the cell after the code had run. I just needed to put in a Cancel
= True.

Now why didn't I think of that in the first place?!?