![]() |
Auto Open and Passing variable value(s) to MS Word
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 |
Auto Open and Passing variable value(s) to MS Word
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 |
All times are GMT +1. The time now is 10:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com