Skip a cell
 

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

--
Message posted from http://www.ExcelForum.com

Skip a cell
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


A workbook that i just recieved at work has a column that excel
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
my workbooks?


---
Message posted from http://www.ExcelForum.com/

Skip a cell
 

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

steveB

(Remove 'NOSPAM' from email address if contacting me direct)


"scottnshelly " wrote in
message ...
A workbook that i just recieved at work has a column that excel
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 my
workbooks?


---
Message posted from http://www.ExcelForum.com/

Skip a cell
 

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!