So I am trying to prevent future users from HIDING ROWS, and instead be able to DELETE rows. As I Understand it, unchecking the Format boxes and checking the delete boxes should allow me to do just that :
image_2023-04-24_105944203.png
Sadly it appears that unchecking the format boxes ALSO disables the deleting of said rows. Asking chatGPT it seems there used to be HIDE ROWS boxes in previous versions... but for now this is where I'm at
image_2023-04-24_110241444.png
Any idea of a solution ? Chat GPT Proposed a VBA script but it doesn't work well
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.EntireRow.Hidden Then Target.EntireRow.Hidden = False
End Sub
Bookmarks