Auto Open problem 1

[ribhead]

I recently got a different PC with Excel 2003 ( I think) and when I open a form that has an Autpen Sub the program stops and won't continue. I don't get an alarm or anything. Is there a setting that I need to change?

Thanks, Rib

Bartender:Hey aren't you that rope I threw out an hour ago?

Rope:No, I'm a frayed knot.

 

[PHV]

Have you checked your macro security level ?
menu Tools -> Macro -> Security ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ribhead]

PHV it's medium

Thanks, Rib

Bartender:Hey aren't you that rope I threw out an hour ago?

Rope:No, I'm a frayed knot.

 

[ribhead]

I wrote another test program trying to show a form in Autpen and it does the same thing.
Both times the form pops up for a milisecond disapears then brings up the immediate window highlighting UserForm1.Show

?????????

Thanks, Rib

Bartender:Hey aren't you that rope I threw out an hour ago?

Rope:No, I'm a frayed knot.

 

[PHV]

No error message ?
Have you checked the references ?
While in VBE, menu Tools -> References ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ribhead]

What do I need a Reference to?

Thanks, Rib

Bartender:Hey aren't you that rope I threw out an hour ago?

Rope:No, I'm a frayed knot.

 

[PHV]

I meant no MISSING reference ?
Did the project compile OK ?
while in VBE, menu Debug -> Compile VBAProject

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ribhead]

P.H. Yes the project compiled O.K. My project always stops on UserForm.show I'm now plucking my left eyeball out.

Thanks, Rib

Bartender:Hey aren't you that rope I threw out an hour ago?

Rope:No, I'm a frayed knot.

 

[PHV]

You haven't answer my 1st question: No error message ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ribhead]

PH Sorry, I stated it in my first post but no I'm not getting any error messages whatsoever.



Thanks, Rib

Bartender:Hey aren't you that rope I threw out an hour ago?

Rope:No, I'm a frayed knot.

 

[byundt]

Workbook_Open is the preferred name of the Autpen sub these days. Autpen is still grandfathered in, but you won't find it in the on-line help.

If you make the Workbook_Open sub public (such as by removing the keyword Private), then you can run it without the inconvenience of opening the workbook. More importantly, you can step through your code a line at a time. To do this, click in the margin to the left of the instructions. This will put a big maroon dot there--and the code will stop executing at that point. You can then execute a line at a time with F8 or continue execution to the next stop with F5.

I've had trouble getting correct error messages when a fatal error occurs in the code pane behind a form. By stepping through the code a line at a time, I was finally able to identify the line of code that was throwing the error.