Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I format my worksheet so that the cursor goes only to cells t.
|
#2
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy a cell (content AND format) from one worksheet to a. | Excel Worksheet Functions | |||
Format a worksheet to carry out all calculations to 2 decimal plac | Excel Discussion (Misc queries) | |||
Format a worksheet to carry out all calculations to 2 decimal plac | Excel Discussion (Misc queries) | |||
How can I format a worksheet to carry out all calculations to 2 d. | Excel Discussion (Misc queries) | |||
Curious Worksheet Format | New Users to Excel |