Userform not running when document is opening

[angel2903]

Hi all,

i have the following code:

Private Sub userform1_Open()
    Range("Ag4").Select
    OPENMESS.Show
End Sub

when I test it in the macro window it works but this does not work when the document opens. This ducoment comes from a sharepoint server and a user needs to enable the document before editing. Is this enabling the cause of the userform (OPENMESS) not running when document is open

[Izandol]

Code must be:

Private Sub Workbook_Open()
    Range("Ag4").Select
    OPENMESS.Show
End Sub

and this must be located in ThisWorkbook module.

[angel2903]

Hi Izandol,

Thank you. It is located in ThisWorkbook module. I have changed as per the bold above.

now it opens but gives me a RUN TIME ERROR 424

[Izandol]

If the userform is named OPENMESS then I think you have error in the code for Userform_Initialize or Userform_Activate events. You may press f8 and step through code to locate the error after the debug message.

[angel2903]

Thank you very much Isandol. REP has been send.

[Izandol]

You are welcome - and thank you.