Help Needed Assigning Macro to Form Control Button in VBA

[sax2play]

Hello All,

I have a macro that generates two form control buttons. Each form control button has its own macro assigned to it. All three macros are saved to my personal macro workbook.

My challenge is that I use the first macro to format a daily report that I need to then distribute to my team and I want the two form control button macros to automatically save in the daily workbook that is generated so my team can use the buttons. Currently I am copying the macro out of my personal workbook and adding it to the daily workbook, but I would like to automate this with VBA when I generate the daily report. Is this possible??

Thanks!

 

[Anthony47]

The simplest way is that you create a "Daily_Report_Model.xlsm" that includes the feature you want; then Save it with "Suggested Read Only" flag
When you create your daily report you start from such "model".

To save with "Suggested Read Only", don't use the "Save" button in Menu /File /Save interface; select "Other options" (just below the file name and the file format text boxes), and you will go to the windows style File save dialog box; exapand "Tools" near the Save button, General options: here you have the "Read only recommanded" check box, to be checked before saving the file. This will prevent that your pseudo-model be modified by error.

The more sophisticated option is that you create a real template, and start from that Template to create your daily reports

Bye

 

[sax2play]

Perfect that's exactly the solution I was looking for! Not as easy as I wanted, but it will be better in the long term. Thanks for your help!

 

[Anthony47]

Not as easy as I wanted

OMG... File /Open / "Daily_Report_Model.xlsm"

To make it easier, add a command to your Quick Access Toolbar that open the file for you.

Bye