I am wondering if anyone knows if it is possible to disable the shift key at startup to prevent users from over-riding macros. Any help with this would be greatly appreciated!
Just in case anyone is interested. I figured out a workaround. (Actually I read something similiar and adapted to my needs)
Make all but a 'Notes' sheet invisible by default. Add a Function that makes all sheets visible upon a condition in code upon start up. Upon close re-set the sheet to invisible.
This way if the user disables macros they won't be able to see any info anyways.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.