Hi there, I have 10 merged cell need to be locked after it's filled with date. The 10 merged cell: E46:F46 E47:F47 E48:F48 E49:F49 G46:I46 G47:I47 G48:I48 G49:I49 J46:L46 J47:L47 The current condition of the worksheet its password protected with "123" and all the 10 merged cell above its unlocked. What I want the VBA code to do: After enter the date and save the workbook, the cell can't be edit anymore, for example I enter a date in E46:F46 merged cell after I save the workbook it will be password protected. The balance merged cell it's not password protected until its fill with the date. Popup a message if the blank cell is filled with wrong data, only accept date data, example: 26/09/2018 Hope it can be achieved via VBA. Thanks.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

vba locked filled merged cell with password and blank merged cell remain unlock

Thread starter ahjeff86
Start date Sep 26, 2018
Tags

cell date excel merged vba

ahjeff86

New Member

Sep 26, 2018

Hi there, I have 10 merged cell need to be locked after it's filled with date.

The 10 merged cell:
E46:F46
E47:F47
E48:F48
E49:F49
G46:I46
G47:I47
G48:I48
G49:I49
J46:L46
J47:L47

The current condition of the worksheet its password protected with "123" and all the 10 merged cell above its unlocked.

What I want the VBA code to do:

After enter the date and save the workbook, the cell can't be edit anymore, for example I enter a date in E46:F46 merged cell after I save the workbook it will be password protected.
The balance merged cell it's not password protected until its fill with the date.
Popup a message if the blank cell is filled with wrong data, only accept date data, example: 26/09/2018

Hope it can be achieved via VBA.
Thanks.

Last edited: Sep 26, 2018