Locking Columns after todays date has passed

[aidan5800]

Hi, I have read a few posts on this but cant get this to work for me. I have a table with dates in the row headers (dates for every friday) and data is manually entered on a weekly basis in each column. I'd like a way to automatically lock the data (with a password) for each previous week up to the current date. See attached file.

Thanks.

[LeoTaxi]

With Sheet Protection, in exemple 'test'
Password to show all = also 'test'

code for buttons

Please Login or Register  to view this content.

In workbooks open

Please Login or Register  to view this content.

Kind regards
Leo

[aidan5800]

Thanks for this though I cant open the file as it say the file format or extension is not valid? I'm using excel 2010.

Thankyou.

[aidan5800]

Ok I managed to run the code though when commandbutton2 is pressed, it hides all cells after 29 June and locks ALL cells down. Then commandbutton1 unlocks and unhides all. What I want is to lock (not hide) all columns prior to todays date but always be able to edit the current weeks value. Hope that makes sense.

[bakerman2]

In ThisWorkbook module.

Please Login or Register  to view this content.