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
Thanks!
Bank-rec-template.xlsm
VBAMicrosoft Excel* reconciliation* LockingMicrosoft Office
Last Comment
Roy Cox
ASKER CERTIFIED SOLUTION
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.
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.
ASKER
I added a new question because I had to change some stuff on the workbook.
Please provide a link to the new question.
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