On Oct 22, 10:52*am, Dave Peterson wrote:
I don't know.
Where did you put it?
Did you call it Auto_Open?
If you're new to macros:
Debra Dalgleish has some notes how to implement macros hehttp://www.contextures.com/xlvba01.html
David McRitchie has an intro to macros:http://www.mvps.org/dmcritchie/excel/getstarted.htm
Ron de Bruin's intro to macros:http://www.rondebruin.nl/code.htm
(General, Regular and Standard modules all describe the same thing.)
wx4usawrote:
<<snipped
Hi Dave,
I cannot get the form to open automatically when the workbook is
opened. It will work when I hit run sub with the VB editor window. Did
I put it in the wrong place?
--
Dave Peterson
Hi Dave
Thanks so much for your help.
I pasted the following...
Option Explicit
Sub Auto_Open()
SalesEntry.Show
End Sub
Under the This workbook tab. The top of the window says general and
auto_open
SalesEntry is the user form name.
I can manually run the macro, but not automatically.
It will not auto open when the workbook is opened. I have to click
enable content. Is there a security issue? Should it auto open after I
click enable content?