View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Luke Bailey Luke Bailey is offline
external usenet poster
 
Posts: 6
Default Run Code on Cell Select

Hello,

I have a couple of questions on Excel Spreadsheet. I have a protected
worksheet that does not allow users to select locked or unlocked cells.
Ideally, I would like users to have a cell that when clicked on, runs a bit
of code. I thought I could accomplish by inserting a button, then setting
background to opaque and shawdows to false. This does work, but you can
still see outline off the button (which I do not want). Any other way to
accomplish this?

I am willing to compromise and let the protection of the form allow users to
select locked cells if necessary. But would also like to have the mouse
change to a different pointer when over that cell (which was working with the
button as well).

Thanks for any ideas!