Thread: If activesheet is called X, then do y
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Die_Another_Day Die_Another_Day is offline
external usenet poster
  
Posts: 644
Default If activesheet is called X, then do y
Assuming everything exists..
Run ActiveSheet.Name

Charles
xl Geek

Darin Kramer wrote:
Hi guys,

I need some VBA that says if the active sheet is "dogs", then call macro
entitled get dogs. If active sheet is "cats", then call macro entitled
"get Cats".

Possible...?

Thanks!!

D


*** Sent via Developersdex http://www.developersdex.com ***

Reply With QuoteReply With Quote