Can I format my worksheet so that the cursor goes only to cells t.

[Dave Peterson]

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]

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

tammyj wrote: