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
|