Select Case for Active Worksheet syntax.
 

I need help arriving at Select Case for active worksheet syntax. For
example

Select Case Worksheet.Activated
Case "Sheet2"
(code goes here)
PrintChecks"
Case "Sheet3"
(code goes here)
End Select

Thanks a lot. mikeburg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=474294

Select Case for Active Worksheet syntax.
 

Hi Mike,

Try:

Select Case ActiveSheet.Name


---
Regards,
Norman



"mikeburg" wrote in
message ...

I need help arriving at Select Case for active worksheet syntax. For
example

Select Case Worksheet.Activated
Case "Sheet2"
(code goes here)
PrintChecks"
Case "Sheet3"
(code goes here)
End Select

Thanks a lot. mikeburg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile:
http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=474294

Select Case for Active Worksheet syntax.
 

thank you mikeburg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=474294