Calling Sheet functions to Sub Workbook_Open Event??

Isn't there a way that I can call a sub from sheet 2 from ThisWorkbook? I made the sub public but I get an error right off the hop. I tried moving it to a regular module but then I get an error stating "Sub or Function not defined". I moved it to ThisWorkbook and get the same error. Possibilities?

I'm going to go out on a limb and say no to all of the above.

Hi barryleajo, the sub I am calling works in the sheet and was private but I changed it to Public, still no! There are no syntax errors as it works in the sheet module.
I tried a few different wayst to call it. For example:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

All with no luck. Instead of trying to call the procedure I took the code within it and put it into the Private Sub Workbook_Open() event. Oh and that is where I was calling the sub from, the Private Sub Workbook_Open() event.

I just tried that too and I still get error "Sub or Function not defined"

I tried that too and I tried moving the sub into ThisWorkbook and then renaming it to no avail!

That's alright barry, as I said I put the code into the workbook open event and everything is good, instead of calling it as a sub.

If the code was in a worksheet code module, then you have to call it as a method of that sheet (using the sheet's code name):

Please Login or Register  to view this content.

for example.