Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Ted Collins   on Feb 03 In MS Office Category.

  
Question Answered By: Eshe Chalthoum    on Feb 03

Well.. just about everything you described is POSSIBLE.
what would you PREFER.

ActiveWorkbook.Path will give you the PATH name of the file.
I use absolute pathnames instead of mapped drives because users
may have different drives mapped.
so, my shortcuts point to \\servername\pathname rather than
"G:\pathname"
In you macro, test for this path, then if doesn't match, exit sub.

If you want to match usernames, let me know and I'll locate the code for that.

Share: 

 

This Question has 27 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Restrict workbook to network Or get search suggestion and latest updates.


Tagged: