Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! * |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
Password Protection - paste to unprotected cell locks the cell | Excel Discussion (Misc queries) | |||
Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
sheet protection - only selected range to be able to select/input data | Excel Worksheet Functions | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) |