Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
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) | |||
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) | |||
Over=protection - Can't even select a cell | Excel Programming |