Positive Aging Act of 2007 - Amends the Public Health Service Act to : (1) require the Secretary of Health and Human Services to make grants to public and private nonprofit entities for projects to demonstrate ways of integrating mental health services for older adults into primary care settings and for multidisciplinary geriatric mental health outreach teams in community settings where older adults reside or receive social services; (2) require the Director of the Center for Mental Health Services to designate a Deputy Director for Older Adult Mental Health Services to address the mental health needs of older adults; (3) require the inclusion of representatives of older adults and their families and geriatric mental health professionals on the Advisory Council for the Center; (4) designate as a project of national significance the treatment of older adults with substance-related disorders; and (5) require state plans under the Community Mental Health Services Block Grant program to describe outreach to, and services for, older individuals and individuals who are homeless and living in rural areas.