read only cell
Is there a macro that I can wright that would make a cell read only on a form
after date entry has been performed in the cell? The intent is to have the initiator of a form complete fields/cells on the form that will become read only after the initiator has completed the form and save the form and then email the form to the next approver. The next approver should not be able to make changes to the content of the initial form that was submitted to the next approver that the initiator emailed to the approver. Any help that you could provide would be greatly appreciated. |
read only cell
Hi,
You would want to use a Worksheet_Change event to handle this, the details would be dependent on your worksheet and we would need a lot more details. The above event can be found as follows 1. Press Alt+F11 2. In the Projects window at the top left of the VBE expand the list under your file name. 3. Double-click the sheet that the code would be working on, for example Sheet1 4. On the top left side of the code window is a object drop down open it and choose Worksheet 5. On the top right side of the code window is a procedure drop down, open it and choose Change. Into this even you will add code that does whatever you need. Note that some of what you need might be handled under Tools, Protection, Allow Users to Edit Range. In fact you might be able to use this feature without the need for a macro, just depends on exactly what you are trying to do. For example if User 1 doesn't enter something is User 2 allows to enter into that area. Or does each user have only their cells to work with? -- Thanks, Shane Devenshire "pdaws" wrote: Is there a macro that I can wright that would make a cell read only on a form after date entry has been performed in the cell? The intent is to have the initiator of a form complete fields/cells on the form that will become read only after the initiator has completed the form and save the form and then email the form to the next approver. The next approver should not be able to make changes to the content of the initial form that was submitted to the next approver that the initiator emailed to the approver. Any help that you could provide would be greatly appreciated. |
read only cell
Thanks ShaneDevenshire, The following is the scenario:
1) User 1 completes the form and forwards the form to User 2 to approve. 2) User 2 just reviews the form that User 1 completed and clicks the approve button on the bottom of the form. 3) User 2 should not be able to make any edits to the information that User 1 entered on the form. I would like to know if there is a way to accomplish this? Thanks. "ShaneDevenshire" wrote: Hi, You would want to use a Worksheet_Change event to handle this, the details would be dependent on your worksheet and we would need a lot more details. The above event can be found as follows 1. Press Alt+F11 2. In the Projects window at the top left of the VBE expand the list under your file name. 3. Double-click the sheet that the code would be working on, for example Sheet1 4. On the top left side of the code window is a object drop down open it and choose Worksheet 5. On the top right side of the code window is a procedure drop down, open it and choose Change. Into this even you will add code that does whatever you need. Note that some of what you need might be handled under Tools, Protection, Allow Users to Edit Range. In fact you might be able to use this feature without the need for a macro, just depends on exactly what you are trying to do. For example if User 1 doesn't enter something is User 2 allows to enter into that area. Or does each user have only their cells to work with? -- Thanks, Shane Devenshire "pdaws" wrote: Is there a macro that I can wright that would make a cell read only on a form after date entry has been performed in the cell? The intent is to have the initiator of a form complete fields/cells on the form that will become read only after the initiator has completed the form and save the form and then email the form to the next approver. The next approver should not be able to make changes to the content of the initial form that was submitted to the next approver that the initiator emailed to the approver. Any help that you could provide would be greatly appreciated. |
All times are GMT +1. The time now is 03:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com