Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
more macro help - freeze panes | Excel Discussion (Misc queries) | |||
Macro for removing columns/rows, freezing panes etc? | New Users to Excel | |||
More Dividers for Excel Viewing Panes / multiple panes per axis. | Excel Discussion (Misc queries) | |||
Locking panes | Excel Programming | |||
Panes sequence. Pane Index 2 & 3 depend on how panes are created | Excel Programming |