View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Workbooks_open()

1) Make sure your Workbook_Open code is in the ThisWorkbook module.
2) Ensure your macros are enabled when you open the workbook. If they
aren't, it won't work.
3) Ensure that the events are enabled. I ran into this problem early on.

HTH,
Barb Reinhardt

"Bill" wrote:

Using excel 2003 vba
When I open a workbook I want it to display a message from itself
This will be the first and only workbook user will see

Public Sub workbook_open()
MsgBox "hello"
End Sub

Is this possible?
By the way the above code does not work
If I solve this the rest of my code will be fine

Bill