On Oct 23, 7:53*am, Dave Peterson wrote:
You have two choices.

Move the code to a general module (insert|Module).

Or rename the procedure (and leave it under the ThisWorkbook module).
Option Explicit
Sub Workbook_Open()
* SalesEntry.Show
End Sub



wx4usawrote:

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?

--

Dave Peterson

I am not sure what a general module is. What does that mean Dave?