Run an existing macron on all the sheets

[jeriss]

Dear,

I have the below code on my Excel that is being run by the "Freeze" icon button on the top.

However, currently it freezes only the data of the sheet "GENERAL"

I want this macro to freeze the data of ALL the sheets. How could I adjust that?

Please Login or Register  to view this content.

Thanks
Simon

[MKLAQ]

untested
maybe like this

Please Login or Register  to view this content.

[jeriss]

Like this?

Please Login or Register  to view this content.

[MKLAQ]

wrong !!
change this

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[jeriss]

Your suggestions don't work at all. Please have a look the file!

[MKLAQ]

sorry buddy ! just I suggest for you . I no know about your file contains many macro.
But why you don't say what's the problem to understand what happend with you ?
may be the others members understand & help you.

[jeriss]

I explained the problem in the initial post... please read above, I have a Macro that runs for 1 sheet but I want it to executes itself on ALL sheets...