View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default startup macro does not execute

Did you put it in the ThisWorkbook module of that workbook?

In that module put it in:
Private Sub Workbook_Open()

RBS


"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