I have a button on a worksheet that the user clicks after entering data in a
couple of cells, the problem is the button will not work until the user
clicks out of a cell they are supposed to input data in.

I have all the cells locked except the cells I want them to enter info into
and the sheet is protected. Any Ideas? thanks.

Button from the forms toolbar or commandbutton from the control toolbox
toolbar?

Under the protection tab of format control for the popup menu associated
with the "button", do you have "locked" unchecked?

--
Regards,
Tom Ogilvy




"Arnold Klapheck" wrote:

I have a button on a worksheet that the user clicks after entering data in a
couple of cells, the problem is the button will not work until the user
clicks out of a cell they are supposed to input data in.

I have all the cells locked except the cells I want them to enter info into
and the sheet is protected. Any Ideas? thanks.

Guess it really doesn't make any difference, because you can't click either
one in edit mode.

--
Regards,
Tom Ogilvy


"Arnold Klapheck" wrote:

I have a button on a worksheet that the user clicks after entering data in a
couple of cells, the problem is the button will not work until the user
clicks out of a cell they are supposed to input data in.

I have all the cells locked except the cells I want them to enter info into
and the sheet is protected. Any Ideas? thanks.

The only time the button dosn't work is when the user has entered info into a
cell, the user has to click out of the cell, then click the button for it to
work, I want the user to be able to enter info and immediatly click on the
button. Hope this clarifies.

maybe try a commandbar button on a floating toolbar.

--
Regards,
Tom Ogilvy


"Arnold Klapheck" wrote:

The only time the button dosn't work is when the user has entered info into a
cell, the user has to click out of the cell, then click the button for it to
work, I want the user to be able to enter info and immediatly click on the
button. Hope this clarifies.