Over=protection - Can't even select a cell
 

Check the Sheet properties in the VBE, it sounds like
EnableSelection = xlUnlockedCells
if so change it to
EnableSelection = xlNoRestrictions

Cheers

Dave

"Gordon Humphreys" wrote in message
...
I'm not sure if this is the right place to ask: if not perhaps you can
point in the right direction.

I have been converting a system based on Excel 4 macros to VB with
valuable help from this group. All going well until ...

One user has invested in new computers, one with Widows XP home, the
other with professional.

The system protects each sheet as it progresses through the work,
leaving some cell unlocked for entry later.

But with XP the protection operation results in total 'glassing-over' ie
it is not possible even to select a cell, let alone edit it. Unlocking
cancels the problem but is not safe (the systems are used by doctors so
need to be foolproof).

The code used is simple:
Sub VBProtect()
ActiveSheet.Protect "password"
End Sub

Is there some trick I am missing?




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!