Can't get two macros to run from a single command button on a protected worksheet

[Lbischoff]

I have a protected worksheet with data entry rows of A1:P126 that are only printed if they contain data per the first macro below. I am trying to get this to be run within the Email_sheet code below but can't seem to figure it out.

Was hoping someone could help me out on how to combine these to run from a single command button.

Thanks in advance

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Neil_]

Just add this to somewhere in the Email_Sheet code (where it is unprotected).

Please Login or Register  to view this content.

As the sheet is protected, you could set the UserInterface property to true to allow macros to run. Do this by protecting your sheet in the immediate window of the VB Editor rather than the ribbon.

Please Login or Register  to view this content.

[meabrams]

If both macro are function as designed then just place a call for the other macro in the macro you want to run first.
So for instance if you want it to run after PrintMarkedRows then Place a call at the end of the macro before the End Sub that looks like Call Email_Sheet…

It should look something like this

Please Login or Register  to view this content.