Works on Microsoft-OS’s and requires WIN32OLE !!
Originally, this application was meant as a work-around, because my spreadsheet-software does not allow the simultaneous selection of several sheets within the same workbook, like it is possible in MS-Excel. Reproducing for other sheets the same page-layout, as was just configured for only one of them can be a chore under this condition. This script-based solution does it by the click of a button, or two, in case you have not yet decided upon which layout to copy.
ATTN! I do not use any Microsoft-Office, but another product, which can be controlled by what looks like a subset of the usual OLE-Objects, you might remember from VBA. It may be necessary (or not) to adjust the code to conform to the needs of your own spreadsheet-program. Especially the range of available properties for the page-setting may vary and should probably be verified. Changes should be easy, as the names of those settings must be noted only once within an Array of “Properties”.
Speak now or forever hold your peace:
Version 0.0.2
I had to modify the script, because the PageSetup-object which is read or modified can no longer be referenced outside the sheet, that it belongs to.
The code is actually much better, now, but I am having doubts if this can work with any other spreadsheet-program than SoftMaker-Office.
Some feedback would be appreciated, also, about necessary changes to make it work.
be referenced outside the sheet,.
Here is a screen-shot of the dialog in action, showing both ways to reference a spreadsheet-table, either by name or by index.
It works for me that way, but of MS-Excel I know nothing.