Is there a way to hide the gridlines on all the sheets in Excel using Applescript, rather than going sheet by sheet? For example, the following only applies to the current sheet selected -
set display gridlines of window 1 to false
Thank you!
MacBook Pro, Mac OS X (10.4.8)
Hi,
Like this
-------------------
tellapplication"Microsoft Excel"
setSheetNametonameofactive sheet
selectworksheets
setdisplay gridlinesofactive windowtofalse
selectsheetSheetName
endtell
-------------------
Hi,
Like this
-------------------
tellapplication"Microsoft Excel"
setSheetNametonameofactive sheet
selectworksheets
setdisplay gridlinesofactive windowtofalse
selectsheetSheetName
endtell
-------------------
Hi Jacques,
Worked like a champ - Thank you! Just so I understand, could you explain the purpose of the set SheetName? Is this used to "de-select" the worksheets and get back to a single sheet?
Thanks!
Hi krt1,
krt1 wrote:
Just so I understand, could you explain the purpose of the set SheetName? Is this used to "de-select" the worksheets and get back to a single sheet?
Because the command that selects all sheets active the first sheet.
So if you work on other sheet than the first, it's not right that the script activate the first sheet.
Hi Jacques -
I just started using this, but I can't 'ungroup' the sheets. If ALL of the sheets are group and you select another sheet (selectsheetSheetName), they still stay grouped. Is there another way to remove the 'select worksheets'?
Thanks!
Hi,
Yes, you can use activate object
------------
tellapplication"Microsoft Excel"
activate
setSheetNametonameofactive sheet
selectworksheets
setdisplay gridlinesofactive windowtofalse
activate objectsheetSheetNameofactive workbook
endtell
Hiding Gridlines on all sheets in Excel using Applescript
