Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for a way to run a macro when the workbook is opened
Hello,
I am trying to put together a macro that when I open the workbook, will automatically start and select a worksheet within the workbook, and then select a specific cell "A2" within that worksheet and then run my specific macro. Any help would be appreciated Thanks BOB REYNOLDS |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for a way to run a macro when the workbook is opened
Hi Bob
to run a macro when the workbook opens in the VBE Window - Project Explorer - double click on "ThisWorkbook" - in the code area choose from the left hand side drop down, Workbook and the sub Workbook_Open should be created for you. Place your code inside here e.g. Private Sub Workbook_Open() Sheets("Sheet1").Activate Range("A2").Select Call mymacro End Sub Hope this helps Cheers JulieD "Bob Reynolds" wrote in message ... Hello, I am trying to put together a macro that when I open the workbook, will automatically start and select a worksheet within the workbook, and then select a specific cell "A2" within that worksheet and then run my specific macro. Any help would be appreciated Thanks BOB REYNOLDS |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for a way to run a macro when the workbook is opened
Julie, Thanks so much and thanks to all who take their time to help us out
on these boards, your time is very much appreciated. Bob Reynolds "JulieD" wrote in message ... Hi Bob to run a macro when the workbook opens in the VBE Window - Project Explorer - double click on "ThisWorkbook" - in the code area choose from the left hand side drop down, Workbook and the sub Workbook_Open should be created for you. Place your code inside here e.g. Private Sub Workbook_Open() Sheets("Sheet1").Activate Range("A2").Select Call mymacro End Sub Hope this helps Cheers JulieD "Bob Reynolds" wrote in message ... Hello, I am trying to put together a macro that when I open the workbook, will automatically start and select a worksheet within the workbook, and then select a specific cell "A2" within that worksheet and then run my specific macro. Any help would be appreciated Thanks BOB REYNOLDS |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for a way to run a macro when the workbook is opened
you're welcome
"Bob Reynolds" wrote in message ... Julie, Thanks so much and thanks to all who take their time to help us out on these boards, your time is very much appreciated. Bob Reynolds "JulieD" wrote in message ... Hi Bob to run a macro when the workbook opens in the VBE Window - Project Explorer - double click on "ThisWorkbook" - in the code area choose from the left hand side drop down, Workbook and the sub Workbook_Open should be created for you. Place your code inside here e.g. Private Sub Workbook_Open() Sheets("Sheet1").Activate Range("A2").Select Call mymacro End Sub Hope this helps Cheers JulieD "Bob Reynolds" wrote in message ... Hello, I am trying to put together a macro that when I open the workbook, will automatically start and select a worksheet within the workbook, and then select a specific cell "A2" within that worksheet and then run my specific macro. Any help would be appreciated Thanks BOB REYNOLDS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to stop Excel remembering/loading macro from previously opened Workbook | Excel Discussion (Misc queries) | |||
How to run a macro as soon a a workbook (.xls) is opened? | Excel Worksheet Functions | |||
Can macro/userform run depending on HOW workbook is opened? | Excel Discussion (Misc queries) | |||
Run a macro when a workbook is opened | Excel Programming | |||
Run a macro when a workbook is opened | Excel Programming |