Worksheet.Protection userinterfaceonly:=true problem

[Kained]

Hi there,

Please excuse mistakes with my submission, am relatively new to posting.

I have develeped a simple UI for an Access database with Excel, it is a workbook that contains 1 sheet. It builds an SQL query on a few selectable cell criteria and retrieves information from a central MSAccess Database.

The user of this tool can then update this information and return it to the database. However, I have unlocked only certain range of columns and permitted editing. The remainder is for information only.

With the Workbook Open event I have used the following to protect the sheet.

Please Login or Register  to view this content.

This does indeed protect the sheet but it has an undesirable effect in that the keyboard cursor movemens are restriced on the unlocked cells. Left & Right is fine. Up and Down keystrokes do not work. Very wierd.

To resolve this I have set the worksheet property EnableSelection = 0 xlNoRestrictions.

This will now allow full keyboard cursor use, but now has an undesired effect in allowing the non editible cells to be selected resulting in the familiar dialog box "The cell or chart you are trying to change is protected and therefore read only... etc.. etc..."

I'd like to protect the sheet, and not allow the cells to be selected. I would have thought my original method would have accomplished this but for the undesired keyboard anomoly.

Has anyone had similar experiences or can shed any light on the subject?

Thank your for your time.

[royUK]

You have other posts so you should know to use Code Tags in your posts, this is covered in the Rules.

[Kained]

I'd appreciate any thoughts on this. I had zero luck so far in other forums also...

http://www.vbaexpress.com/forum/show...460#post176460

[Richard Schollar]

Can you post a sample workbook which exhibits this problem? Remove any confidential data first (and make sure the workbook isn't too big).

Richard

[royUK]

Are you using the direction arrows on the keyboard?