Macro/VBA Questions:

[reneev]

1) Uncheck boxes with Macro Button - I have created a form in Excel which when protected, users can tab through and fill out either by typing, drop down boxes or checking a box. I created a macro button to "Clear Form" but the only thing it won't clear are the check boxes even though I've unchecked them while recording the macro. I'm using the legacy check boxes if that matters

2) Once I've created the macro, I cannot go back in and edit or delete it. I get an error: "Cannot edit a macro on a hidden workbook. Unhide the workbook using the Unhide command" Except, I don't have any hidden workbooks! I'm having to recreate the entire macro if I need to edit it.

3) I need this macro to be able to be run by different people on their own computers.

I'm not very experienced in VBA or Macros.

 

[reneev]

Put the macro in a module inside your thisworkbook, I'm afraid with that your 2 questions are solved.

How do I do that? Do I need to re-record the macro or copy/paste?

 

[DanteAmor]

Press Alt-F11 to open the VBA editor. From the menu select Insert > Module. On the sheet that opens, paste the code.

On your sheet, press right mouse button on your button, select the option Assign macro:

In the next window. In the Macros in field, select Thisworkbook
In the panel select your macro and press OK.


Note: (the images only contain examples, you must use the actual data of your book)