Hi,
I want to ask regarding the previous post regarding the Auto Open
method, I have put this simple code :
Sub Workbook_Open()
MsgBox("Auto Open Macro Success")
End Sub

and it still showing up the Enable Macro screen. What's wrong ?.

Secondly, How do you pass a variable value from a MS Excel worksheet
to a MS Word document ?.

Lastly, tons of thanks.

rgds
sony

Sony,

Sub Workbook_Open()
It should be "Private Sub Workbook_Open" and it
should be in the "ThisWorkbook" module. I suspect that
you have it in a regular module (and it won't work from there).

and it still showing up the Enable Macro screen.
If you have any code in a workbook and your security setting
is set to "Medium", you'll get this alert every time. Other than
using a digital signature (which is a chore in itself, and expensive)
or setting your security setting to "Low" there isn't any way around this.

John




"Sony" wrote in message
...
Hi,
I want to ask regarding the previous post regarding the Auto Open
method, I have put this simple code :
Sub Workbook_Open()
MsgBox("Auto Open Macro Success")
End Sub

and it still showing up the Enable Macro screen. What's wrong ?.

Secondly, How do you pass a variable value from a MS Excel worksheet
to a MS Word document ?.

Lastly, tons of thanks.

rgds
sony