Command Buttons not responding

[Naftas]

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

 

[joel]

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


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

 

[Joel]

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]

Hi joel,

as I have said nothing was chaged in last god run.
I am not in design mode there are no duplicate macros or macros with same
name. Also same file works fine on my college computer without any problem.
All command buttons are in function. On my computer macro security is set to
LOW.

Have you any other ideas!
Best regards,
Naftas

 

[Naftas]

When I have tried to add new command button from Control Toolbox next message
appeared:

"Microsoft Map is no longer supported with Microsoft Office Excel"

Hi joel,

as I have said nothing was chaged in last god run.
I am not in design mode there are no duplicate macros or macros with same
name. Also same file works fine on my college computer without any problem.
All command buttons are in function. On my computer macro security is set to
LOW.

Have you any other ideas!
Best regards,
Naftas

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.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=152998

Microsoft Office Help

.