go from input cell to input cell
I would like the user to go from input cell to input cell. I got the answer:
protect all cells - unlock input cells, protect wkst - use tab key. I used tools/protection/protect sheet. Tab is now disabled. Is this not the correct follow through? And can I make it so the user can also use Enter to get the same results? |
go from input cell to input cell
Hi
before you protect the sheet, choose the cells that you want the user to get to and choose format / cells - go to the protection tab and choose unlocked. now protect the sheet - the tab key should take you from unprotected cell to unprotected cell. as far as i know you can't do it with the enter key. Cheers JulieD "Toinett" wrote in message ... I would like the user to go from input cell to input cell. I got the answer: protect all cells - unlock input cells, protect wkst - use tab key. I used tools/protection/protect sheet. Tab is now disabled. Is this not the correct follow through? And can I make it so the user can also use Enter to get the same results? |
All times are GMT +1. The time now is 01:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com