Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Disable the Shift Key in Excel2000

Status
Not open for further replies.

binky

Programmer
Jan 25, 2001
183
CA
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!

Ken ::)
 
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.

Ken ::)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top