Change Key Mapping
 

I have a fairly simple spreadsheet that I have protected columns with
formatting symbols. I want the users to only enter single digit values
into the unprotected cells and automatically skip the protected cells
containing a "," or ".". This seems to work when I use the TAB key.
However, if I press the Right Arrow or Enter key, I can end up on a cell
that is protected.
My question:
Is there a way to force the ENTER and RIGHT ARROW keys to behave as if a
TAB was pressed?

Change Key Mapping
 

before protecting the sheet, select the properties for the sheet and set the
enable selection property to xlUnlockedCells

you can access the properties of the worksheet in the VBE project explorer
by hitting F4 with the sheet selected to bring up the properties window

Another method is wish the sheet visible, make the control toolbox toolbar
visible and click the properties icon.

The setting for enable selection is lost when you close the workbook, so you
must set it each time the workbook is opened. You could do that in the
workbook_open event and if the user doesn't disable macros, it will be set
each time the workbook is opened.

--
Regards,
Tom Ogilvy

"Paul S Panoff" wrote in message
...
I have a fairly simple spreadsheet that I have protected columns with
formatting symbols. I want the users to only enter single digit values
into the unprotected cells and automatically skip the protected cells
containing a "," or ".". This seems to work when I use the TAB key.
However, if I press the Right Arrow or Enter key, I can end up on a cell
that is protected.
My question:
Is there a way to force the ENTER and RIGHT ARROW keys to behave as if a
TAB was pressed?

Change Key Mapping
 

Thank You! I will experiment with that!

Tom Ogilvy wrote:

before protecting the sheet, select the properties for the sheet and set the
enable selection property to xlUnlockedCells

you can access the properties of the worksheet in the VBE project explorer
by hitting F4 with the sheet selected to bring up the properties window

Another method is wish the sheet visible, make the control toolbox toolbar
visible and click the properties icon.

The setting for enable selection is lost when you close the workbook, so you
must set it each time the workbook is opened. You could do that in the
workbook_open event and if the user doesn't disable macros, it will be set
each time the workbook is opened.

--
Regards,
Tom Ogilvy

"Paul S Panoff" wrote in message
...
I have a fairly simple spreadsheet that I have protected columns with
formatting symbols. I want the users to only enter single digit values
into the unprotected cells and automatically skip the protected cells
containing a "," or ".". This seems to work when I use the TAB key.
However, if I press the Right Arrow or Enter key, I can end up on a cell
that is protected.
My question:
Is there a way to force the ENTER and RIGHT ARROW keys to behave as if a
TAB was pressed?