How to set the current layer
Currently working on a macro to aid a fellow mapper over at the cartographer's guild. He wants to export each sheet to a png so he can work some photoshop magic on them. This has lead me to one major question:
How on earth do I set the current sheet? I've found the commands for hiding and deleting sheets, but nothing for setting the current one. This is bad, because you can't hide the active sheet, so I need to be able to set this. I suppose I could have a requirement be 'you must have the common sheet set as active' before running the macro, but that's really bad coding :p
Edit:
Ok, two questions. Is there a way to enumerate all sheets, or do I have to hard code the sheet names in?
How on earth do I set the current sheet? I've found the commands for hiding and deleting sheets, but nothing for setting the current one. This is bad, because you can't hide the active sheet, so I need to be able to set this. I suppose I could have a requirement be 'you must have the common sheet set as active' before running the macro, but that's really bad coding :p
Edit:
Ok, two questions. Is there a way to enumerate all sheets, or do I have to hard code the sheet names in?
Comments
Set current sheet: SSET
Not sure if it is possible to enumerate them.