Unsharing a workbook
 

i'm trying to come up with a way to have my workbook say "if i'm not i
drive I: then i can't be a shared workbook"

I need it so that when i do a savecopyas of the workbook(which i
shared) to another drive it won't open up as a shared workbook. Tha
way, people in our department can share the workbook, and people tha
aren't in our department can't.
Any suggestions

--
Message posted from http://www.ExcelForum.com