| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to run on file open
Hi
Is there a way to start a macro running as soon as a file opens? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro to run on file open
Private Sub Workbook_Open() Call YourMacroName End Sub hth Vaya con Dios, Chuck, CABGx3 "Marie Bayes" wrote: Hi Is there a way to start a macro running as soon as a file opens? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro to run on file open
This needs to be put in the ThisWorkbook module.
-- Don Guillett SalesAid Software "CLR" wrote in message ... Private Sub Workbook_Open() Call YourMacroName End Sub hth Vaya con Dios, Chuck, CABGx3 "Marie Bayes" wrote: Hi Is there a way to start a macro running as soon as a file opens? Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro to run on file open
Yup, I forgot to mention it...........thanks for the catch Don.
Vaya con Dios, Chuck, CABGx3 "Don Guillett" wrote: This needs to be put in the ThisWorkbook module. -- Don Guillett SalesAid Software "CLR" wrote in message ... Private Sub Workbook_Open() Call YourMacroName End Sub hth Vaya con Dios, Chuck, CABGx3 "Marie Bayes" wrote: Hi Is there a way to start a macro running as soon as a file opens? Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro to run on file open
Thanks
"CLR" wrote: Yup, I forgot to mention it...........thanks for the catch Don. Vaya con Dios, Chuck, CABGx3 "Don Guillett" wrote: This needs to be put in the ThisWorkbook module. -- Don Guillett SalesAid Software "CLR" wrote in message ... Private Sub Workbook_Open() Call YourMacroName End Sub hth Vaya con Dios, Chuck, CABGx3 "Marie Bayes" wrote: Hi Is there a way to start a macro running as soon as a file opens? Thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro to run on file open
Hi
Thanks for that, I've put this into a module, when I run it, all works fine, but when I open my spreadsheet, nothing happens, is there something else I need to do? "CLR" wrote: Yup, I forgot to mention it...........thanks for the catch Don. Vaya con Dios, Chuck, CABGx3 "Don Guillett" wrote: This needs to be put in the ThisWorkbook module. -- Don Guillett SalesAid Software "CLR" wrote in message ... Private Sub Workbook_Open() Call YourMacroName End Sub hth Vaya con Dios, Chuck, CABGx3 "Marie Bayes" wrote: Hi Is there a way to start a macro running as soon as a file opens? Thanks |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro to run on file open
That's what Don was saying.........are you sure you put it in the
"ThisWorkbook" module? Right-click on a Tab, ViewCode then double-click on the "ThisWorkbook" module and paste in the right hand window. Vaya con Dios, Chuck, CABGx3 "Marie Bayes" wrote: Hi Thanks for that, I've put this into a module, when I run it, all works fine, but when I open my spreadsheet, nothing happens, is there something else I need to do? "CLR" wrote: Yup, I forgot to mention it...........thanks for the catch Don. Vaya con Dios, Chuck, CABGx3 "Don Guillett" wrote: This needs to be put in the ThisWorkbook module. -- Don Guillett SalesAid Software "CLR" wrote in message ... Private Sub Workbook_Open() Call YourMacroName End Sub hth Vaya con Dios, Chuck, CABGx3 "Marie Bayes" wrote: Hi Is there a way to start a macro running as soon as a file opens? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open a group of files in speadsheed on the same book | Excel Discussion (Misc queries) | |||
| Macro syntax to open file in current explorer folder | Excel Discussion (Misc queries) | |||
| How to stop file open macro prompt after deleting all macros? | Excel Worksheet Functions | |||
| cannot open excel file, please help!!! | Excel Discussion (Misc queries) | |||
| Macro to open specific File | Excel Discussion (Misc queries) | |||
Hybrid Mode
