Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tab key functionality in a protected worksheet
Is there a way to retain the tab key functionality (to tab across cells) in a
protected worksheet. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tab key functionality in a protected worksheet
This is some code I found some years back:
Amend as needed and put it into the ThisWorkBook module. It allows users to select unprotected cells only and works great with the tab key. Select UnProtected Cells ONLY This will prevent users from clicking on protected cells on all worksheets. Therefore, the warning message will not appear. The code must be enterred in the ThisWorkbook module. Note that the EnableSelection property must be reset each time the workbook is opened as it defaults to xlNoRestrictions. The worksheet(s) must first be unprotected to set the EnableSelection property and then must be protected for it to take effect. Private Sub Workbook_Open() Dim WS As Worksheet For Each WS In ThisWorkbook.Worksheets WS.Unprotect 'Password:="wxyz" WS.EnableSelection = xlUnlockedCells WS.Protect 'Password:="wxyz", UserInterfaceOnly:=True Next End Sub Regards, Greg Wilson 5/3/03 -- steveB Remove "AYN" from email to respond "Lowkey" wrote in message ... Is there a way to retain the tab key functionality (to tab across cells) in a protected worksheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit text format in non-protected cells in protected worksheet | Excel Discussion (Misc queries) | |||
Do not allow Copy/Paste Functionality in a Protected Sheet | Excel Worksheet Functions | |||
Running of Worksheet Change Macro breaks undo functionality. | Excel Discussion (Misc queries) | |||
Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
Enable 'BOLD' functionality in protected Excel spreadsheet | Excel Discussion (Misc queries) |