View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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