cannot click button on sheet
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. |
cannot click button on sheet
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. |
cannot click button on sheet
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. |
cannot click button on sheet
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. |
cannot click button on sheet
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. |
All times are GMT +1. The time now is 08:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com