| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open Macro Dialog Box | Excel Programming | |||
| control of dialog macro dialog box. on open | Excel Programming | |||
| end Macro after cancelling open dialog | Excel Programming | |||
| Open file Dialog box in Macro | Excel Programming | |||
| Open dialog in macro | Excel Programming | |||
Threaded Mode
