Workbooks_open()
 

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

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

Workbooks_open() -solved thankyou
 

"Barb Reinhardt" wrote:

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

Workbooks_open()
 

Set the Security level to low/medium in (Tools|Macro|Security). 'Launch VBE
using short-key Alt+F11. On the left treeview double click 'This Workbook '.
Drop down to get Private Sub Workbook_Open() event. Place your code-- Save
and reopen

If this post helps click Yes
---------------
Jacob Skaria


"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