Auto Macro in Excel 2007

vjs2445

New Member
Joined
Apr 6, 2009
Messages
46
Is there any complete list of the auto excel macro exists?

For example:

Auto_open()
Auto_Close()

What are the other auto macros I can utilize in Excel 2007?

Thanks and regards,
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
You can use Workbook_Open and Workbook_BeforeClose in the module for ThisWorkbook. To find the other events use the dropdowns at the top of the Code pane in the Visual Basic Editor. There are also sheet events available in the module for a worksheet.
 
Upvote 0
Press ALT + F11 to open the Visual Basic Editor. In the Project window double click ThisWorkbook. In the left hand dropdown, near the top select Workbook. The right hand dropdown will give you a list of event procedures.
 
Upvote 0

Forum statistics

Threads
1,224,583
Messages
6,179,674
Members
452,937
Latest member
Bhg1984

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top