Avatar of Max Hersey
Max Hersey
Flag for Canada asked on

Locking cells based on cell values

hey i am looking to have the cash on hand reconciliations do the same thing that the bank account reconciliations do. Once the difference is 0, then you can lock the reconciliation by clicking the button.  The reconciliations are the tabs from Oct  to Jun. Also, can we add an if coding so that the bank reconciliation can not be locked until they put a date in? Currently it says Please enter statement date in red but I want my staff to have to put in the date before it will actually lock.  Also, if the date has not been put in can a message box pop up saying that the bank statement date has not been entered?

Thanks!
Bank-rec-template.xlsm
VBAMicrosoft Excel* reconciliation* LockingMicrosoft Office

Avatar of undefined
Last Comment
Roy Cox

8/22/2022 - Mon
Roy Cox

Is this what you mean?

I have added code to check the balance is zero and a sate is entered, the macro is called LockSht. I have added a button on the October sheet, if it is doing what you want then add buttons to the other sheets and assign the macro, it will work on any of the reconciliation sheets.

You can add a password to the code if you want
Bank-rec-template.xlsm
ASKER CERTIFIED SOLUTION
Roy Cox

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Max Hersey

ASKER
Not quite. I think i messed up the spreadsheet though. so its all good. i should have tried to fix it before i posted.
Max Hersey

ASKER
I added a new question because I had to change some stuff on the workbook.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Roy Cox

Please provide a link to the new question.