Author Topic: More Sheet Sets - re-arranging existing sheets  (Read 161 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..

DonHayes

  • Mosquito
  • Posts: 2
Re: More Sheet Sets - re-arranging existing sheets
« Reply #1 on: December 16, 2018, 11:12:53 PM »
Hindi ko alam kung gaano karaming mga pag-update ang ginawa upang hindi ako makatutulong sa pagrerekomenda sa kanila.