Protecting Transactions Sheet

[Tech56]

Hi,

How can the Transactions sheet have protection for all cells but B3, E6:F15, and A to J starting in row 29 and continue down ? These are the only cells that will have entries. All other cells need to be protected and not edited.

 

[Tech56]

I used macros to unprotect sheet then protect sheet for the solution.

 

[herofox]

HELLO,You can to Use This Code in Transactions Page 'Code

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim Rng1            As Range  '
     Set Rng1 = Range("A1:A28,B1:C2,B4:E5,C1:F4,B4:D28,E16:F28,G1:J28,K1:XFD1048576")
     If Intersect(Target, Rng1) Is Nothing Then
  sw = 1
     Else
   Range("B3").Select
  
      End If
End Sub

 

[Tech56]

Thank you for the code herofox.

I was able to make it work with this method. I called the codes to run within the show / hide buttons as well as protecting the table.

What do you think?

 

[herofox]

i think my way better than your way ,because you can't write any thing in protect Cells

 

[Tech56]

That's the idea. The protected cells contain formulas. The unprotected cells are the ones the user will input data.

I am not sure how next month's Recurring Transactions macro is going to work though. I guess I will find out.

Thanks herofox

 

[Tech56]

Hi can you take a look again? I made some transactions for August in rows 29 to 46. I clicked the 'Add This Month's Recurring Transactions' to add September's recurring. It pasted to the bottom instead of starting in row 47. Can the code be modified to find the next blank row instead?

Thank you