#1
|
|||
|
|||
Limit cell range use
How do you restrict or limit row and column use for the entire work session? I would like the tab function to move the cursor to the next cell and say stop at column G then move to the next row. |
#2
|
|||
|
|||
Hi,
try this (Excel 2003): (sorry for any incorrect translation, I am using a Swedish Excel version). Mark the cells you want to use (for example A1:G20) Select menu: Format / Cells. Click the tab "Protection". Unclick the checkbox "Locked". To make this choice active (the "Locked" you did above), you must now protect the whole sheet. Select menu: Tools / Protection / Protect sheet. Before pressing "OK", unclick the checkbox "Mark locked cells". Kind regards Bjorn |
#3
|
|||
|
|||
Close!
Tack Bjorn. I appreciate the speedy reply.
The Protect Sheet options are: "contents, objects, scenarios" (all with optional password). Before that Tools\Protection offers protect: sheet, workbook and protect and share workbook. They do not display this option either! It might be elsewhere but I see what you are trying to achieve. My version is Excel 2004 for Mac so they must have put it in a different place. Anyone know where? |
#4
|
|||
|
|||
Quote:
|
#5
|
|||
|
|||
Response...
Bjorn, I tried it on the 2003 version and it works well as you said. I did select the cells on the 2004 version but it didn't work as I couldn't find the protect page option. I'll try it when I'm back on the mac again.
|
#6
|
||||
|
||||
Hi talkinglens,
You can limit the usable area with a macro like: Code:
Sub Auto_Open() ThisWorkbook.Sheets("Sheet1").ScrollArea = "A1:J10" End Sub Code:
Private Sub Workbook_Open() ThisWorkbook.Sheets("Sheet1").ScrollArea = "A1:J10" End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
nice..
Wow. Very coool. I'll try that. It's very direct and succinct!
JK |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
4K size limit, Outlook 2003 Task Export | sizzling4 | Outlook | 1 | 08-21-2010 04:52 PM |
How to determine a user's mailbox size limit? | enviroko | Outlook | 3 | 05-13-2010 07:02 AM |
Moving formula range multiple cells when moving sum over one cell | FraserKitchell | Excel | 4 | 02-26-2010 10:38 AM |
Maximum limit on Inbox folders?? | KarenK | Outlook | 0 | 12-29-2009 10:38 PM |
Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |