Want to apply condition to run a code

[HaroonSid]

hi,

i am using this code to hide my sheets...

Please Login or Register  to view this content.

but somethime Sheet Name "PrintOut" doesn't available. so this code is giving debug error

i want condition that
if sheet name "PrintOut" available then run this code other wise run below code

Please Login or Register  to view this content.

thanx

[cytop]

Read Error handling in VBA

[HaroonSid]

found an answer

Please Login or Register  to view this content.

[cytop]

It would be more logical to actually handle the error correctly rather than essentially duplicating procedures (except for 1 line). Next week you add HIDE_ALL_SHEETS3?