sql - Lock database for other application -

i'm using sql server 2008 r2, using database via macro code in excel, there way prevent application (like excel) access database?

if users supposed acces database (they have login , rights on it) limited range of software, have tell them not use excel. there workaround based on after connect trigger wich check application_name in session, not effective.

if not have connect directly database, have delete logins (or revoke rights) or change password if shared common user.