View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default Excel forms button "click"

Greetings! I have a spreadsheet that uses several forms buttons with a macro
assigned to each. When I first created this spreadsheet under an older
version of Excel, clicking the button would produce a visual "in/out"
movement of the button. Now I'm using Excel 2002 (SP3), and the visual
movement doesn't appear unless you click *and hold* the mouse button for
about two seconds. This spreadsheet is used by university students in my lab,
so they would click the button several times, not realising that the macro
had run (it executes a calculation and writes results to another sheet in the
workbook). I solved that problem by adding a "beep" to the macro, but that
means I have to install speakers on the computers (which have a tendency to
grow legs and walk out of the lab) when we perform this experiment. Is there
a time delay setting that adjusts the speed of the button's click motion?
Thanks.