I am trying to call on 2 separate procedures on the same workbook like so
Private Sub Workbook_Open()
Protect_Me
End Sub
_______________________
Private Sub Workbook_Open()
frmLogin.Show
End Sub
I get a compile error, I think it has to do with both Sub's having the same name..... I tried renaming the frmLogin Sub, and it will not call the form, If I rename the Protect_Me Sub, it will interfere with the vba code on that Macro and will not let me run some other macros on the workbook unless I unlock the sheet manually, which is not what I would like to do. Keeping the name as is on the Protect_Me Sub, the macros run just as they should on the sheet.
How do I get around this problem?
Thanking you all in advance...
Cheers
Tony
Bookmarks