excel - Message Box if Workbook opened outside 'Home' directory -


i administrator of small excel macro enabled membership database held , operated through dropbox , accessible selected individuals.

i wondering whether possible set 'home' directory of workbook, if saved or copied individuals computer, or moved out of 'home', msgbox appears informing user workbook cannot opened in directory , closes.

if possible, plan modify ask administrator password, if correct, workbook operates normally, if not, closes.

thanks in advance.


Comments

Popular posts from this blog

c++ - llvm function pass ReplaceInstWithInst malloc -

Cross-Compiling Linux Kernel for Raspberry Pi - ${CCPREFIX}gcc -v does not work -

java.lang.NoClassDefFoundError When Creating New Android Project -