Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - Skip a cell | Excel Discussion (Misc queries) | |||
why does my tab key skip to next page instead of next cell | Excel Discussion (Misc queries) | |||
Skip cell if X nonexistent, populate next cell | Excel Discussion (Misc queries) | |||
skip to next cell if no value is found | Excel Discussion (Misc queries) | |||
Skip a cell that contains data | Excel Worksheet Functions |