Name your macro

sub Auto_Open()
place in a REGULAR module

now in the ThisWorkook module add another macro

Private Sub Workbook_Open()
call Auto_open
End Sub

Now you have covered ALL contingencies.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Artie" wrote in message
...
I created a macro named auto_run to run when I open a specific workbook.
It
does not run upon opening the workbook but it does run when I go to Tools
macro run.
The instructions are
sheets ("consolidated") . select
range ("f11") . select
end sub

Macro security is set to low.
--
Artie