Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-28-2010, 08:13 AM
talkinglens talkinglens is offline Limit cell range use Mac OS X Limit cell range use Microsoft Office 2004 for Mac
Novice
Limit cell range use
 
Join Date: Dec 2010
Posts: 9
talkinglens is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 12-28-2010, 10:32 AM
BjornS BjornS is offline Limit cell range use Windows Vista Limit cell range use Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

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
Reply With Quote
  #3  
Old 12-28-2010, 07:55 PM
talkinglens talkinglens is offline Limit cell range use Mac OS X Limit cell range use Microsoft Office 2004 for Mac
Novice
Limit cell range use
 
Join Date: Dec 2010
Posts: 9
talkinglens is on a distinguished road
Default 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?
Reply With Quote
  #4  
Old 12-29-2010, 03:20 AM
Kimberly Kimberly is offline Limit cell range use Windows 7 Limit cell range use Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

Quote:
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.
Select the range before you start.
Reply With Quote
  #5  
Old 12-29-2010, 10:30 AM
talkinglens talkinglens is offline Limit cell range use Mac OS X Limit cell range use Microsoft Office 2004 for Mac
Novice
Limit cell range use
 
Join Date: Dec 2010
Posts: 9
talkinglens is on a distinguished road
Default 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.
Reply With Quote
  #6  
Old 12-29-2010, 11:16 PM
macropod's Avatar
macropod macropod is offline Limit cell range use Windows 7 32bit Limit cell range use Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi talkinglens,

You can limit the usable area with a macro like:
Code:
Sub Auto_Open()
ThisWorkbook.Sheets("Sheet1").ScrollArea = "A1:J10"
End Sub
in a general module, or:
Code:
Private Sub Workbook_Open()
ThisWorkbook.Sheets("Sheet1").ScrollArea = "A1:J10"
End Sub
in the workbook's 'ThisWorkbook' module.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 12-31-2010, 08:43 PM
talkinglens talkinglens is offline Limit cell range use Mac OS X Limit cell range use Microsoft Office 2004 for Mac
Novice
Limit cell range use
 
Join Date: Dec 2010
Posts: 9
talkinglens is on a distinguished road
Default nice..

Wow. Very coool. I'll try that. It's very direct and succinct!
JK
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Limit cell range use 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
Limit cell range use 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft