Macro that is worksheet specific can't be found

I have a macro that I want to run as part of open event. I recorded the macro to copy and paste some columns on a worksheet. This macro will only work when I am on that worksheet.

Since I want to run this macro as one of many applications when workbook is open and it doesn't always open on this specific worksheet I would like the code to target the worksheet and run the macro.

Here is my code :
Application.Run "'Workbook.xlsb'!Sheet5.Copy_Paste2"

I get this message: "Cannot run the macro "..." The macro may not be available in the workbook or all macros may be disabled."

I know macros are not disabled because the others ones that are not worksheet specific run just fine

No it's not called Workbook, I just didn't want to use the real name. The code is located in a module. I recorded the macro on the worksheet and I'm trying to run it as part of an open event with a couple of other macros that I wrote the code for and are not worksheet specific and those work just fine when called from the open event.

I'm not sure. I just recorded it while on the tab and then tried to run it as part of the open event with two other macros that are not worksheet specific.