View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Nicole Nicole is offline
external usenet poster
 
Posts: 53
Default onClick in Excel

Cool...many thanks to both of you :)

"Nicole" wrote:

Is it possible to have a cell automatically display an "X" when a user clicks
on it e.g. using the onClick in VBA? The user does not want to use the "tick
box" under the forms toolbar. He would like an "X" in a cell when he clicks
on it or even double click. The worksheet will also be protected at the end
so that only certain cells can be added. Is this possible? If yes, how would
I go about it? Any ideas?

Regards

Nicole