Macro deactivated in specific worksheet

[graiggoriz]

Hello,

Would it be possible not to run a macro in specific worksheet?? I run a macro with the shortcut CTRL + P and I need to have that macro to be deactivated on certain worksheets (the worksheet names are "RENTCU1", "RENTCU2", "RENTCU3", "RENTCU4".

Thanks,
Graig

[nathansav]

put an activesheet.name check at the start of the macro.

[graiggoriz]

Thanks but I need to have it work the other way around. I would like to specify the worksheets I do not want to macro to be run.

[Norie]

Does this macro run on multiple worksheets when you call it or only on the active sheet?

[Arkadi]

can you post your macro? it is hard to know how to help with the code if we don't know what we are helping on. Do you reference the worksheet in your macro? Does the macro loop through all sheets?

[graiggoriz]

Sure!

My macro is that one:

Please Login or Register  to view this content.

The worksheets that I do not want that macro o be run are: "RENTCU1", "RENTCU2", "RENTCU3", "RENTCU4"

Many Thanks in advance.
Graig

[graiggoriz]

Sure!

My macro is that one:

Please Login or Register  to view this content.

The worksheets that I do not want that macro o be run are: "RENTCU1", "RENTCU2", "RENTCU3", "RENTCU4"

Many Thanks in advance.
Graig

[nathansav]

Yes, thats what i was getting at, in the 1st line of macro have

Please Login or Register  to view this content.

[HaHoBe]

Hi, graiggoriz,

maybe add this to ThisWorkbook and see if it works as expected:

Please Login or Register  to view this content.

Ciao,
Holger

[graiggoriz]

Hello Holger,

Are you saying that I need to *** that code in the 4 worksheets? (right click on the tab; view code. and add the code?

If so, I already have the below code in each worksheet. If you meant to add the code differently can you please provide me the step? I don't know how to do that...

Please Login or Register  to view this content.

Many Thanks,
Graig

[mikerickson]

I think this will do what you want.

Please Login or Register  to view this content.

[graiggoriz]

Hey mikerickson!! You got it!! Very good.

I only have on problem with the printing part as if I cancel the printing I see the macro and in the file I use there is password! Would you know if the below macro can be enhanced and give me a pop up "would you like to print that document" and putting a condition that if "no" then it ends the macro instead of entering in debug mode! In the end I need to print that document as pdf but I did not know how to do that so I recorded a macro (CTRL + P)

Do you think you could help me with that matter?

Please Login or Register  to view this content.

Many Thanks,
Graig

[Arkadi]

graig, change it to:

Please Login or Register  to view this content.

[graiggoriz]

Hello,

Thanks to all! I have compiled the macros and got that:

Please Login or Register  to view this content.

I have the following error:
Compile error:
Block If without End If

Can you please help me fixing that error?

Many thanks,
Graig

[HaHoBe]

Hi, graiggoriz,

indention could be one way to find the error, this is untested (I shifted some of the lines):

Please Login or Register  to view this content.

Ciao,
Holger

[graiggoriz]

Hello,

Thanks to all! I have compiled the macros and got that:

Please Login or Register  to view this content.

I have the following error:
Compile error:
Block If without End If

Can you please help me fixing that error?

Many thanks,
Graig

[HaHoBe]

Hi, Graig,

I don´t get the reason for repeating the post from 08:50 PM at 10:15 PM (I know there have been Forum issues and my post wasn´t properly displayed nor passed to my count nor was displayed on the survey of the Forum). Did you try my suggestion?

Ciao,
Holger

[Arkadi]

your 'print version section has an if, no end if. The end if near the bottom applies to "if not" at the top. I suggest adding an "End If" just before "End Sub"