Automatically enter date into a column and make that column read only

**Mr Davo** · 10-18-2012, 01:35 AM

Hi Everyone,

I have a date column in my spreadsheet and there are several actions that I would like to apply to it -

1). Auto populate the date column with the current date only when the column to the left has data entered into it (please see below)

Date-Entry.jpg

2). Make the date column read only so that it cannot be modified by other parties.

Any help will be greatly appreciated.

Kind Regards,

Davo

**Winon** · 10-18-2012, 01:55 AM

Hello Mr. Davo,

That can be done with sheet protection, but if Data in the Column to the left of the Locked Column is changed the Date and Time in the Locked Column would adjust automatically.

Is that O.K. with you?

**Mr Davo** · 10-18-2012, 02:06 AM

That will be fine. Can you please send me a link that explains sheet protection?

**Winon** · 10-18-2012, 02:19 AM

Hello Mr. Davo,

See the attached WorkBook, it is quite self explanatory.

Also see the "Please consider" note at the bottom of this post.

**Mr Davo** · 10-24-2012, 01:13 AM

Hello Winon,

Thank you very much for your response. I have noticed in the Protect Column.xls file which you generously supplied that every time a change occurs in the left column (e.g.: each time I add a new letter in the screen capture below), that all dates / times update for every letter that has been entered previously -

Change-to-all-dates-&-times.JPG

Is there any way of "disconnecting" each row, such that only one date / time gets updated whenever a new item is entered, or an existing item is altered?

Any further assistance will be greatly appreciated.

Kind Regards,

Davo

**Winon** · 10-24-2012, 01:14 PM

Hi Mr. Davo,

I am quite tied up at the moment, but I promise to have a look into this as soon as I have time.

We may have to resort to VBA. is that O.K. with you to run Code with this project, and could it effect other users?

**Mr Davo** · 10-24-2012, 07:58 PM

Hi Winon,

Thanks so much for your help with this. My intention is to deploy the spreadsheet to SharePoint Online - it is to be accessed across several states. As I am not familiar with VBA I would not like to see you put in a lot of time only to discover that it won't work with SharePoint / Office 365. Can you please point me in the right direction to learn more about the direction that your suggesting? I will then be able to decide whether what I am trying to achieve is worth pursuing or not.

Kind Regards,

Davo