Excel Macro Advise.....To Open The Template Dialog.....
"Brian Taylor" wrote:
You have to make sure to put it in the workbook code section. Go into
the VBE and and instead of putting the code in a regular module, double
click on ThisWorkbook in the project explorer. This should open the
code section for the workbook. Paste the code in that section.
An even better method is, once you open the workbook code section, if
you click on the drop down that says general and change that to
workbook then you will get a list of event triggers in the second drop
down. You can select open from that list and it will create the
workbook_open event sub header for you. Let me know if my explanation
makes sense.
|