Hi I have created a number of buttons that do various jobs but I seem to have
turned them all off, as none of them now work.
any idea what I have done?

Thanks in advance

Wildauk

somebody posted this a while back

hit alt-f11

hit ctrl-g (to see the immediate window)
type this and hit enter:
application.commandbars("worksheet menu bar").Enabled = true
=======

then
tools|customize|toolbars tab



--


Gary


"wildauk" wrote in message
...
Hi I have created a number of buttons that do various jobs but I seem to have
turned them all off, as none of them now work.
any idea what I have done?

Thanks in advance

Wildauk

Are you in Design mode still ?
Check the icon with the ruler/pencil/set square on the Control Toolbox.

NickHK

"wildauk" wrote in message
...
Hi I have created a number of buttons that do various jobs but I seem to
have
turned them all off, as none of them now work.
any idea what I have done?

Thanks in advance

Wildauk

Hi,

Did you you ever used the CTRL key to copy/select controls on your form. In
certains case, it creates an exact copy of your control with
same caption but with new names like commandButton7... but without any code
associated with it.
Check in the Control list Dropdown in the properties window if you find any
controls like commandButton7, or
move your button and look if it cover your original control.
Regards
Jean-Yves

"wildauk" wrote in message
...
Hi I have created a number of buttons that do various jobs but I seem to
have
turned them all off, as none of them now work.
any idea what I have done?

Thanks in advance

Wildauk

Hi Jean,
On your advice I checked the buttons and where I had copyed the
buttons in bulk, I had created up to four buttons on each cell, I singled the
out and now they work.

Thank you.

"Jean-Yves" wrote:

Hi,

Did you you ever used the CTRL key to copy/select controls on your form. In
certains case, it creates an exact copy of your control with
same caption but with new names like commandButton7... but without any code
associated with it.
Check in the Control list Dropdown in the properties window if you find any
controls like commandButton7, or
move your button and look if it cover your original control.
Regards
Jean-Yves

"wildauk" wrote in message
...
Hi I have created a number of buttons that do various jobs but I seem to
have
turned them all off, as none of them now work.
any idea what I have done?

Thanks in advance

Wildauk