Re: Excel: hide multiple columns with Applescript
Re: Excel: hide multiple columns with Applescript
- Subject: Re: Excel: hide multiple columns with Applescript
- From: Paul Berkowitz <email@hidden>
- Date: Sun, 17 Apr 2011 23:24:58 -0700
- Thread-topic: Excel: hide multiple columns with Applescript
Title: Re: Excel: hide multiple columns with Applescript
On 4/17/11 2:26 PM, "Cameron Knowlton" <email@hidden> wrote:
Out of curiosity, I wasn't just missing the technique to address all of the pivot items simultaneously... it's just not possible, is it? i.e. It would be up to the Microsoft developers to have built in access code that they didn't, correct?
Or, am I missing an obvious Applescript reference idiom here?
I don't have a suitable example to test on myself. Have you tried this:
tell pivotTable
set pivotHideCount to (pivotItemCount - 5) -- number of columns to hide, beginning from the left (oldest)
set visible of pivot items 1 thru pivotHideCount of pivot field "Date" to false
end tell
--
Paul Berkowitz
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden