Adding macro button: which option?

The instructions I’ve read on how to add a macro button are usually like this:

1. Go to the Developer tab in the ribbon.
2. Press the Insert button found in the Controls section.

But the next step varies. Some say

3. Select the Button Form Control.

But others say

3. Select the Active X control.

Is there any consensus on this or advice on when to use a particular option please?

The Form button is less quirky than the Active X button. AND it is cross platform with a Mac (which doesn't support ActiveX)

Unless there is a good reason to use the ActiveX version, I'd go with the Forms button. Note that the code for the attached macro should be in a normal module, not the sheet's code module.

Thanks Mike, I’ll choose that.

I’m a VBA novice so could you expand on the distinction you’ve made about module types please?

In the VB Editor, if you double click on worksheet (or the ThisWorkbook icon) in the Project Explorer, the code module for that sheet will open.
The event code (Worksheet_Change, Worksheet_Calculate, etc) code for that sheet goes in that module. So does the event code for ActiveX controls.

If you use the menu to Insert>Module (not Class Module, not Userform) a normal code module will be added to the workbook. General code (that can be called from any module) goes there.

Subs in a Sheet's code module can only be called by refering to the sheet

Please Login or Register  to view this content.

and then only if you declare the sub as Public.
In a normal module, Public is the default type of Sub, and code can be called without refering to the module

Please Login or Register  to view this content.

Thanks Mike, understood.