Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
tammyj
 
Posts: n/a
Default Can I format my worksheet so that the cursor goes only to cells t.


  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Kind of.

First select all your cells (ctrl-A, twice with xl2003) and then
format|cells|protection tab|check locked.

Then select column T
format|cells|protection tab|uncheck Locked.

Then add this little macro to a general module:

Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.Protect Password:="hi"
.EnableSelection = xlUnlockedCells
End With
End Sub

Change the sheet name, the password. Then close the workbook and reopen it to
see if it works.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

(If the user opens with macros disabled, then this won't help.)

tammyj wrote:

--

Dave Peterson
  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

Ps. It's better to post your question in the body of the message--not just in
the subject.

tammyj wrote:

--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I copy a cell (content AND format) from one worksheet to a. Excel Format Copy Excel Worksheet Functions 1 February 9th 05 10:34 PM
Format a worksheet to carry out all calculations to 2 decimal plac Phill Barrett Excel Discussion (Misc queries) 2 January 5th 05 01:07 PM
Format a worksheet to carry out all calculations to 2 decimal plac Phill Barrett Excel Discussion (Misc queries) 4 January 5th 05 01:07 PM
How can I format a worksheet to carry out all calculations to 2 d. Phill Barrett Excel Discussion (Misc queries) 2 January 5th 05 01:05 PM
Curious Worksheet Format PT New Users to Excel 1 December 9th 04 07:23 AM


All times are GMT +1. The time now is 07:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"