Re: Excel: hide multiple columns with Applescript
Re: Excel: hide multiple columns with Applescript
- Subject: Re: Excel: hide multiple columns with Applescript
- From: Cameron Knowlton <email@hidden>
- Date: Mon, 18 Apr 2011 09:59:04 -0700
Title: Re: Excel: hide multiple columns with
Applescript
Hi Paul, thanks for the suggestion. This was the first thing I
tried (it didn't work), but I know I was on the right path.
Cameron Knowlton
At 11:24 PM -0700 11/04/17, Paul Berkowitz wrote:
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
--
Cameron Knowlton
KnowledgeVine SEO Dashboards
email@hidden
P: 250.382.0226
http://www.knowledgevine.net
_______________________________________________
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