I have a template that is set up to display a user form when the template is opened. However the enable macro security bar pops up, and does not allow it to run. After I click enable, the macro still does not run. Is there any way to tell it to run after the user has allowed macros? Other people will be using this same sheet, so telling my computer to always allow macros will not work. I am still very new to VBA, so any help is appreciated