Auto Open and Passing variable value(s) to MS Word

  • Thread starter Thread starter Sony
  • Start date Start date
S

Sony

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()
Click to expand...
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.
Click to expand...
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
 
Back
Top