code is not locking workbooks..

[Jenkins27]

what im trying to get happen in this code is after it copys the value into cell H13 in each workbook I want it to lock the sheet "measurements" in each workbook..
but then it must unlock then the code is run again

Please Login or Register  to view this content.

[TMS]

ThisWorkbook relates to the workbook with the code in it, not the Active Worrkbook, which is the workbook you have just opened.

Use wbOPEN or ActiveWorkbook to refer to the workbook with the Measurements sheet in it. Preferably, wbOPEN to be consistent.


Regards, TMS

[Jenkins27]

I tried this and is still did not work

Please Login or Register  to view this content.

[Jenkins27]

any other ideas anybody?

[TMS]

The .Protect in the original code is against the workbook, not the sheet. In the updated code, you don't have .Protect at all.

Untested, but try:

Please Login or Register  to view this content.

Regards, TMS

[TMS]

Please don't bump your thread after 20 minutes. The people providing answers on this forum do so on a free and voluntary basis. Please be patient if the answer takes a little while. If you have not had an answer or an update after 24 hours, or so, THEN bump the thread.