Form Control Text box
You have to enable macros for macros to run.
And it looks like the current macro assigned to this checkbox is not in a
general module (or at least the pointer to the macro doesn't think so).
Rightclick on the checkbox (not really a textbox, right???) and reassign the
correct macro.
newguy wrote:
The error message I get is "Cannot run the macro 'Test.xlsm!
Sheet1.CheckBox_Click' The Macro may not be available in the workbook
or all macros may be disabled."
I checked the Trust center and allowed Macros to Run and it is in the
General Module.
--
Dave Peterson
|