![]() |
Can I format my worksheet so that the cursor goes only to cells t.
|
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: -- Dave Peterson |
All times are GMT +1. The time now is 03:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com