View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Maybe it's that misplaced undersco

Private Sub Workbook_Open()

Or maybe you have the workbook_open code in the wrong module--it belongs under
the ThisWorkbook module.

Maybe you have security set to high?--change it to medium and answer yes to the
allow macros prompt.

Maybe you held down the shift key when you opened the workbook--stopping the
auto_open and workbook_open code from running.



Callan wrote:

Please help!

I'm using that following "very simple" code

Private_Sub Workbook_Open()
ActiveSheet.PrintOut
End Sub

Yet, Excel does not run ANY code that I put in this function, why?
I even put in a simple [MsgBox "hello", vbokonly] line just to check. But
still nothing.
Will appreciate the help.
Kind Regards,
Cal


--

Dave Peterson