Code Red > VB(A)

More Sheet Sets - re-arranging existing sheets

(1/1)

GILESP:
Hi y'all.

I've had a bit of time to revisit some old projects, and made some progress with manipulating sheet sets with VBA.

One thing I've yet to try is to re-organise existing sheets in a set - I've yet to figure out if it's possible to move a sheet, there are no methods or properties that jump out at me regarding the position of a sheet in the sequence of objects in the sheet set database.
I can insert an existing sheet well enough, and presumably delete (as a matter of cosmic history it has always easier to destroy than create) but I'd rather not use the copy/delete/create principle as I fear it will be inefficient, and some of my users will be accessing the sheet set file over a (slow) vpn.
Has anyone attempted this, or have any thoughts on this?

Navigation

[0] Message Index

Go to full version