Hi,
I am looking for some help here. Attached sheet has 2 macros (before close and after save)
What I am looking is user fill some information in green cells and then close
First macro will take care of this part, it will force user to fill green fields and then it will allow them to close
Second part where I need these fields to get locked once they close the workbook.
Here I am not able to make any success. 2nd code gives me error like "Unable to set the locked property of the range class"
I don't know but to me range is correct .
Can anyone please lookinto this.
Many thanks in advance.
Tom
I am looking for some help here. Attached sheet has 2 macros (before close and after save)
What I am looking is user fill some information in green cells and then close
First macro will take care of this part, it will force user to fill green fields and then it will allow them to close
Second part where I need these fields to get locked once they close the workbook.
Here I am not able to make any success. 2nd code gives me error like "Unable to set the locked property of the range class"
I don't know but to me range is correct .
Can anyone please lookinto this.
Many thanks in advance.
Tom