run two Macros consecutively

[Hassan1977]

Hello

I am trying to run two Macros one after the other, I have used the following

Please Login or Register  to view this content.

but it doesn`t work as Macro2 is sheet based not module based ..

any way around this ?

Thanks

[Andy Pope]

Please Login or Register  to view this content.

Include the sheet codename

[Hassan1977]

I have tried it but I am getting an error ..

Please Login or Register  to view this content.

Any ideas where I went wrong ?

[Andy Pope]

That is the sheets name where as you need to use it's code name. You can check the VBA project for sheets code name, the one NOT in brackets.