I got a button worked before, but it did not work recently.
I opened the workbook, click the button, the button did not fire any event
but only get foucsed (ie, have handles around the button).

Is the button from the forms toolbar or the control toolbox? If Forms -
double check to make sure it is assigned to a macro. If control toolbox,
make sure you are not in design mode (check the control toolbox toolbar and
toggle the design button).


"Man Utd" wrote:

I got a button worked before, but it did not work recently.
I opened the workbook, click the button, the button did not fire any event
but only get foucsed (ie, have handles around the button).

Hi,
I just figured out that my security level is high so the macro is disabled.

"JMB" wrote in message
...
Is the button from the forms toolbar or the control toolbox? If Forms -
double check to make sure it is assigned to a macro. If control toolbox,
make sure you are not in design mode (check the control toolbox toolbar
and
toggle the design button).


"Man Utd" wrote:

I got a button worked before, but it did not work recently.
I opened the workbook, click the button, the button did not fire any
event
but only get foucsed (ie, have handles around the button).