Cant use [alt] + Pg up or pg dn on protected sheet

[slimimi]

Hi there - is there a code to still allow me to move between sheet tabs by using [alt] pg up or [alt] pg dn on a protected sheet?

Thanks in advance.

 

[RoryA]

Selecting them doesn't allow the users to change them! They are still locked!

 

[slimimi]

I know - but i done it this way because it makes it easier for the user to see where they need to enter data (as they are tabbing along the sheet cells).

 

[Mister H]

Hi slimimi:

If you just Protect your sheet the Normal Way if the Users use their TAB key it Automatically will take them to the Next Unprotected cell. Maybe I am missing something here?

Take Care,
Mark

 

[RoryA]

You can also use styles to highlight the unprotected cells to make them clearer.

 

[Greg Truby]

...If you just Protect your sheet the Normal Way if the Users use their TAB key it Automatically will take them to the Next Unprotected cell...

Dang! How come I never knew that? I always thought you had to disallow selecting protected cells before that would happen.

@ Rory -- don't recall seeing that sig last time I rode a thread with you -- but I like it.

 

[Mister H]

Hi Greg:

For the record if the user uses the Arrow Keys or Return then they can still move to the Protected cells. I personally put a Data Validation in a cell at the beginning Text Length between 0 and 0 that simply states:

Welcome:

The EASIEST way to Navigate this form is to use

TAB

to move from one cell to the next. Hit TAB to begin...

Until I read this Post I was not aware of the other feature in Excel (removing the check mark from Select Locked Cells) that would allow the users to move only to Unprotected cells regardless of their keyboard navigation.

I wonder if there is anyone associated with Microsoft or otherwise that actually knows ALL the features of this program ???

Have a GREAT day,
Mark

 

[RoryA]

Greg,

I came across it in a copy of VSTO for Mere Mortals and it struck a chord with me for some reason...

 

[Greg Truby]

...I came across it in a copy of VSTO for Mere Mortals...

I've heard that book mentioned elsewhere. At some point I may attempt to dally in .NET / VSTO. Would you recommend VSTO for Mere Mortals as a good primer for making the jump from VBA?

 

[RoryA]

Definitely! It's aimed squarely at VBA developers making the transition to VSTO (so it concentrates on VB not C# for example).