View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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