View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg H.[_3_] Greg H.[_3_] is offline
external usenet poster
 
Posts: 30
Default Email tabs based on checkboxes

The System:
Outlook 2000
Office 2000
Windows 2000

The Setup:
I have 1 excel document with multiple tabs. There is a "Team" score tab and
"Individual" tabs for everyone on the team. Each "Individual" tab has
specific scores for each member. On the "Team" tab i have check boxes with
each members name associated to it.

The Question:
How can i write code that will email each "Individual" tab to that specific
person only when i check their name on the "Team" tab.