Clearing all previous selections when entering a sheet

[#1]

Hello!

I want to write a Macro with a procedure that will clear all previous selections when I enter a sheet ( I have several sheets: workers, accidents, compensations etc.)

what is the code for this purpose ?

Thanx!!

Nitzan

[Miguel_Angel_Baeyens]

Hello Nitzan,

Fortunately, you don't need to create a macro. Just right click on the sheet you want all fields to be cleared, go to Properties, Triggers, OnActivateSheet, Add a New Action, type Selection, Action "Clear All".

Every time you click on that sheet, all fields will be cleared (as if you click on the Clear button)

Hope that helps.

[#3]

Wow! That was quick and brilliant!!

Thank you so much!

Nitzan

[Miguel_Angel_Baeyens]

Hello Nitzan,

I'm glad to help. Although it's not exactly what you wanted, take a look at this post and the entire thread and the attached application.

Hope that helps.