|
Hi,
Please put next time code into [ code ] [ / code ] tags (without the spaces) for readability.
Method 1: There is no collection of maps, so you have to keep the household of it yourself. A collection is basically just a linked list. But this method is as you self have sayed very memory consuming if you have lots of sheets with maps open.
Method2: Looks nice, but I dont think you can move a map from control to other control. But what you sure can do, is move the whole control from the inactive sheet to the active sheet.
Method3: Just in case 1 and 2 dont work you can have a mp control on all sheet, and open a map on active sheet and always close all other maps. But this will elapse more time. |