Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet
I'm trying to have Excel run a macro I have written when a spreadshee
is opend. I have a windows script that will open Excel for me, and th spreadsheet I need, but so far I've had little luck getting the macr to run. I've coded it into the actual sheet to run when it starts, bu it can never find the macro. :confused -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet
Put the code in the Workbook_Open routine of the Workbook module.
-- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , wyndman says... I'm trying to have Excel run a macro I have written when a spreadsheet is opend. I have a windows script that will open Excel for me, and the spreadsheet I need, but so far I've had little luck getting the macro to run. I've coded it into the actual sheet to run when it starts, but it can never find the macro. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet
Auto run code does not go into the Worksheet module.
Two methods... 1. In a general module Sub Auto_Open() 'your code here End Sub 2. In the ThisWorkbook module Sub Workbook_Open() 'your code here End Sub Gord Dibben Excel MVP On Tue, 25 May 2004 08:27:48 -0500, wyndman wrote: I'm trying to have Excel run a macro I have written when a spreadsheet is opend. I have a windows script that will open Excel for me, and the spreadsheet I need, but so far I've had little luck getting the macro to run. I've coded it into the actual sheet to run when it starts, but it can never find the macro. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoRun Macro | Excel Worksheet Functions | |||
autorun a macro | New Users to Excel | |||
Autorun macro | Excel Worksheet Functions | |||
MACRO AUTORUN | Excel Discussion (Misc queries) | |||
Autorun macro on opening spreadsheet | Excel Programming |