Over=protection - Can't even select a cell
 

On Fri, 08 Aug 2003 23:45:37 -0700, Gordon Humphreys
wrote:

It'd be more useful to know the version of Excel than the version of
Windows (always more useful still to know both, of course), but
assuming that you're encountering this problem in *EXCEL* XP (2002),
my suspicion is that it has to do with the level of protection on each
sheet. Try turning off your protection, and going to Tools -
Protection - Protect Sheet. You'll notice considerably more options
there than in the older versions of Excel. Make sure that (at least)
the Allow Users To Select Unlocked Cells checkbox is checked. My bet
is that it isn't.

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!


---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *