Y
YESHWANT
We are working on a project and since now hard disk drives are available in
huge capacity, it's just becoming impossible for us to restrict "copy"ing or
"save as" functions.
what we are trying to do is create some sort of support file/s and keep them
in some other locations on the computer and ask thru VBA if those specified
files are there, then only open the file. Now we have came across a bug in
this.
under tools-macro-security option, if the security level is set to LOW, the
VBA code is set aside and the file opens. How to avoid this and is there any
other full proof system in excel which can prevent user from surpassing the
restrictions imposed thru VBA code and also copy and/or save as function ??
huge capacity, it's just becoming impossible for us to restrict "copy"ing or
"save as" functions.
what we are trying to do is create some sort of support file/s and keep them
in some other locations on the computer and ask thru VBA if those specified
files are there, then only open the file. Now we have came across a bug in
this.
under tools-macro-security option, if the security level is set to LOW, the
VBA code is set aside and the file opens. How to avoid this and is there any
other full proof system in excel which can prevent user from surpassing the
restrictions imposed thru VBA code and also copy and/or save as function ??