Skip a cell

S

scottnshelly

A workbook that i just recieved at work has a column that exce
automatically skips over when i try to tab to it. it is protected
does that have something to do with it? how can i do this on one of m
workbooks
 
F

Frank Kabel

Hi
the creator has probably protected this worksheet, locked this column
and disabled selecting these locked cellsin the protection dialog
 
S

steveB

There is code that could be doing this. Set your own password...
Greg Wilson posted this:

'''''''''''''''''''''''''''''''''''''
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
'''''''''''''''''''''''''''''''''''''''''
 
G

Greg

I was running xl97 back then. I'm running xl2000 now. You can set the
EnabledSelection property for xl2000 without first having to unprotect
the worksheet(s) in the Workbook_Open event. You still have to reset the
EnableSelection property each time you open the workbook as it does
default to xlNoRestrictions.

Regards,
Greg



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
Top