| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help! Loss of Tab control/cell selection problem
....and through tinkering, I think I solved the problem. Added the following
to the Worksheet_Activate code... -------------------------------------------------------- snip -------------------------------------------------------- .... 340 Die: 345 ActiveSheet.Unprotect "unlock" 350 Application.ScreenUpdating = True 355 ActiveSheet.Protect "unlock", , , True 360 End Sub -------------------------------------------------------- Thanks folks. I hope this helps anyone else with this problem. I'm testing right now with my users and if it didn't work, I'll repost, but this, while not a pretty solution, works on my xl2000 test machine. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hardship letter explaining devastating loss property loss financi | Excel Discussion (Misc queries) | |||
| Page Layout Cell Selection Problem | Excel Discussion (Misc queries) | |||
| Loss of dropdown control when publishing | Excel Worksheet Functions | |||
| Cell selection problem | Excel Discussion (Misc queries) | |||
| Set Focus Problem for textbox control on multipage control | Excel Programming | |||
Hybrid Mode
