Good day,
I need to submit a piece of work today, however every time I click on a check box a popup appears:
"Cannot run the macro "Filename'!CheckBox1_Click'. The macro may not be available in this workbook or all macros may be disabled."
I was trying to clean up any macros that I was not using. and deleted this macro. But every time I click another checkbox this message appears.
I tried adding vba code back with the same name CheckBox1_Click. Renamed the checkbox. No luck so far.
I diabled any links to other workbooks, but it still pops up.
I have search forums and have not found a solution.
Help would be greatly appreciated.
Jo
I need to submit a piece of work today, however every time I click on a check box a popup appears:
"Cannot run the macro "Filename'!CheckBox1_Click'. The macro may not be available in this workbook or all macros may be disabled."
I was trying to clean up any macros that I was not using. and deleted this macro. But every time I click another checkbox this message appears.
I tried adding vba code back with the same name CheckBox1_Click. Renamed the checkbox. No luck so far.
I diabled any links to other workbooks, but it still pops up.
I have search forums and have not found a solution.
Help would be greatly appreciated.
Jo