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.

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.

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.