I have a button-linked Macro that does a month-end calculation when closing a monthly ledger page. However, once the month is “closed”, I want that button to be non-functioning. My thought is to use a cell that, if False would allow the macro to run but if True would abort the call. I’m thinking that an If, Then, Else condition would work but I am at a loss as to the proper syntax/commands to make the condition work. Any thoughts or suggestions would be appreciated.
Don’t post questions as wiki. Only disadvantages.
Hello,
At the beginning of the sub, retrieve the cell string. Then in an if statement:
If cellData = "True" Then Exit Sub