Prevent/disable Hide Rows without using Protect sheet?

excel vba

Is it possible to Prevent/disable Hide Rows without using Protect sheet ? Because some users can hide some rows by mistake.I tried using this code on SelectionChange event but not full prove. Thanks for your help.

Activewindow.displayHeadings = False

Solution 1:

As far as I know, there is no event triggered when a row is hidden.

The following code will not prevent that rows are hidden, but it will immediately show them again when the cursor is set to any other cell.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Cells.EntireRow.Hidden = False
End Sub

Related

How to define a type parameter inside a type parameter in java generics
No signature of method: .android() is applicable for argument types. Exception in build.gradle (app)
'Unsupported driver' error when writing Geodataframe to file in geopandas
Stack with circular progress bar and elevated button in flutter
How do I call java.sql.Connection::abort?
How can I be notified when a new window is created on Win32?
Why are all Google Cloud Function source files replicated for every function deployment?
Jinja2 template: output format
Why does this return "na" as result?
Using multiple filters in .Filter() with GraphServiceClient in .NET application
How to override a nested npm sub-dependency with a different package altogether (not just different package version number)?
How to set JSON Array values to seter class in Android Studio with volley