Hi skrgrl74,
You can do what your asking with the "Messaging" App that came preloaded on the Droid Pro. Start Messaging, then > Menu > Messaging Settings and you will get to a screen where you can change Notification settings for Text, Email, and Social Messaging. You can choose your ring tone, vibrate/not vibrate and status bar notification for each type of messaging. Hope that helps!