How do you tell a macro module to automatically run when the workbook is opened? I am doing a simple copy/paste special values before they are updated and would like the macro to run this without the user having to click on a macro button to run it everytime they open the workbook.

Thank you,
Melinda

In the Project window of the VBA window, double-click This Workbook.

Add the following:

Private Sub Workbook_Open()
Call Macro1' Or whatever your macro name is
End Sub

Fantastic........Thank you!!!!!