Author Topic: More Sheet Sets - re-arranging existing sheets  (Read 356 times)

0 Members and 1 Guest are viewing this topic.

GILESP

  • Newt
  • Posts: 42
More Sheet Sets - re-arranging existing sheets
« on: September 10, 2018, 04:02:15 AM »
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?
..END OF LINE..