Locking panes in macro
I have a macro that does certain things. Among these things I want the macrp
to olck panes. I know how to do this. The problem is that I run the same
macro several times on the same spreadsheet. Thus if the panes are already
locked when I run the macro the program does not work. I then have trued to
unlocking the panes at the beginning of the macro but then I get the same
problem, if panes are not locked when running the macro it does not work. Is
there any way to solve this e.g. some boolean check to see if panes inn fact
are locked or something? i am not ver good at programming so any help is
appreciated! Thanks!
|