Combine 2 worksheet change events

**akderitend** · 09-07-2012, 08:59 AM

Hi

I am trying to combine two worksheet change events without any joy;

Please Login or Register  to view this content.

Im sure its a fairly simple fix but im baffled!

cheers

**tom1977** · 09-07-2012, 09:05 AM

Hi
Get rid of red part from Your code

Please Login or Register  to view this content.

**akderitend** · 09-07-2012, 09:15 AM

Thanks Tom, greatly appreciated.

If i wanted to unhide more than one sheet using the second command code, how would i do that?

**akderitend** · 09-07-2012, 09:19 AM

As in;

Please Login or Register  to view this content.

is this right?

**tom1977** · 09-07-2012, 09:21 AM

In standard module try this

Please Login or Register  to view this content.

**akderitend** · 09-07-2012, 09:36 AM

Apolgies, my vba experience is in starter mode - where does that element of the code go?

**tom1977** · 09-07-2012, 09:39 AM

A little information e.g. here:
http://www.contextures.com/xlvba01.html

**Cutter** · 09-07-2012, 06:57 PM

@ akderitend

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.