ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can I format my worksheet so that the cursor goes only to cells t. (https://www.excelbanter.com/excel-worksheet-functions/17300-can-i-format-my-worksheet-so-cursor-goes-only-cells-t.html)

tammyj

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

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