this posting originated at MS website so I'm responding at both THECODECAGE
and here. Don't blame me for the double posting.

If you are in desing mode and double click the button a new macro will not
be created. If you get a new macro then the name of the button doesn't match
the macro you are using. the macro also need to be in the VBA sheet the
crresponds to the sheet where the button is located. the button will not work
if it is in a different sheet, in a module, or in THISWORKBOOK.


You also need to exit design mode for the button to work. It is possible you
may of create two macros with the same name. I would run COMPILE from the VBA
menu Debug - Compile to make sure there is no errors in your macros.


"Naftas" wrote:

I have sheet with command buttons from Control Toolbox. Everything worked
fine until now. When I have opend my file command buttons stop responding.
Also I can not se their properties when I am in design mode. I can run their
VB code from Visual Basic Editor with Step Into button. Also I have command
buttons from Forms Toolbox on other sheets with charts, they work without any
problem.

Please help!

Naftas