Hi,
As part of a template I'm making, several "on event" macros I have running prompted me to keep one worksheet in the template locked without the ability to select the locked cells. For some reason, this has the side effect of disabling ctrl-pageup and ctrl-pagedown to switch between worksheets. While I could theoretically modify the on events to be more specific and allow locked cells to be selected, that would be a fairly arduous task.
Is there a way to keep these hotkeys active without allowing locked cells to be selected?
Thanks!
As part of a template I'm making, several "on event" macros I have running prompted me to keep one worksheet in the template locked without the ability to select the locked cells. For some reason, this has the side effect of disabling ctrl-pageup and ctrl-pagedown to switch between worksheets. While I could theoretically modify the on events to be more specific and allow locked cells to be selected, that would be a fairly arduous task.
Is there a way to keep these hotkeys active without allowing locked cells to be selected?
Thanks!