G
Guest
I used VBA to create a Login form upon entering an Excel file, but I noticed
that all the user has to do is either hold down the shift key when opening
the file, or choose 'Disable Macros', and then they get full access to the
file. Is there any way of programming to enforce them to 'Enable Macros' in
order to access the file. I.e., if they disable or use the shift key, the
file will not open? (I would rather use VBA to secure the file because of the
ease of purchasing an Excel password-cracking program). Thank you.
Patrick
that all the user has to do is either hold down the shift key when opening
the file, or choose 'Disable Macros', and then they get full access to the
file. Is there any way of programming to enforce them to 'Enable Macros' in
order to access the file. I.e., if they disable or use the shift key, the
file will not open? (I would rather use VBA to secure the file because of the
ease of purchasing an Excel password-cracking program). Thank you.
Patrick