not sure what they call this

[geno32080]

Good Morning
What if I want the user to only be able to work in cells ranged B8:AC43. what do they all that? And can a VBA be created to do that job? Below is the sheet the end user is filling out, The top part populates automatically. the end user just fills out the info from the date (B8) and to the right of that cell.

 

[geno32080]

Good Morning
What if I want the user to only be able to work in cells ranged B8:AC43. what do they all that? And can a VBA be created to do that job? Below is the sheet the end user is filling out, The top part populates automatically. the end user just fills out the info from the date (B8) and to the right of that cell.
View attachment 51716

That's suppose to read "what do the call that"> Sorry

 

[MARK858]

You don't need VBA...

Select the cells
Right Click
Click Format Cells
Click the Protection tab
Uncheck the Locked Cells option (It should be set as Locked by default)
Click Ok
Click the Review tab
Click the Protect Sheet icon
Uncheck the Locked Cells option (and type in a password if you desire)
Click OK
Confirm the password if you have set one

 

[offthelip]

if you do want a vba solution then you can put this in the code of the workhseet:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If (Intersect(Target, Range("B8:AC43")) Is Nothing) Then
   Range("b8").Select
End If
End Sub

 

[geno32080]

That's it ! I was over thinking it. That worked perfect, Thanks..

 

[MARK858]

You're welcome, happy we could help

 

[geno32080]

I tried that VBA, man that's trick. Thanks.