Run Macro after Unfreeze panes

[Bells7028]

I need to run a certain macro after the Unfreeze panes.
Should I use any event, or how can I do it?
Can someone help?
Thanks
Bells

[shg]

There is no event generated by freezing or unfreezing panes.

[Bells7028]

OK. Is there any solution?

[shg]

You could run the code for any other event -- a manual change of a cell, the calculate event, the sheet activate or deactivate event, whatever.

What are you trying to do?

[mehmetcik]

You can check if the panes are frozen or not. So if you set a timer to run a macro every 20 seconds. And that Macro quits if the panes are not frozen. You have a Solution.

Please Login or Register  to view this content.

Tmer programme:-

When the workbook first opens, execute this code:

Please Login or Register  to view this content.

Then just have a macro in the workbook called "EventMacro" that will repeat it.

Please Login or Register  to view this content.

[Bells7028]

What I would like to do is to make a kind of protection of the sheet. Once someone will try to unfreeze panes, macro will delete some cells and the workbook will loose its unique functions and it will be not possible to use it again. As far as I know the protection of the sheet by password is very weak and the password break is very simple.

[Bells7028]

Thank you for your suggestion, however, after launch your xlsm file the runtime error is reported (Runtime error 440) and the row alertTime = Now + TimeValue("00:00:20") is highlighted in debugger. FYI: I am working in MS Excel 2011 for Mac.

[mehmetcik]

I'm afraid it works fine on my pc.

I have no access to a mac.

So you will need to debug this yourself.

google apple mac vba excel timer.