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?