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: Sun, 17 Apr 2011 14:26:40 -0700
Title: Re: Excel: hide multiple columns with
Applescript
A little more insight, now that I can see a difference...
I have the pivot table sorted, which seems to take
a long time to perform when I watch the status (in the bottom left of
the spreadsheet window) with screen updating enabled. I'm going to try
removing the sort, then reinstalling it after all of the
pivot items have been made non-visible, and see if that makes a
difference.
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?
Cameron Knowlton
At 11:38 AM -0700 11/04/17, Paul Berkowitz wrote:
On 4/16/11 12:35 PM, "Cameron
Knowlton" <email@hidden> wrote:
Wow, disabling screen updating DID speed things up
considerably:
Good. Because of the repeat block, and the fact that what it's acting
on is the 'visible' property of many individual (repeated) items, each
of which can take time to register on-screen before the script goes on
to the next repeat iteration, it can make a big difference to just cut
the on-screen manifestations out until it's all done.
Thanks for reporting back.
--
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