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: Mon, 21 Mar 2011 10:22:00 -0700
- Thread-topic: Excel: hide multiple columns with Applescript
On 3/21/11 2:21 AM, "David Wignall" <email@hidden> wrote:
> All of which works but when I tested with a different field, one with 89 items
> it took a noticeable time, complete with SPOD but less than 1 minute, to
> create the list of names. However it took no real time at all to hide all
> those fields, so if you already know the names then that's irrelevant.
> (Errored on the last one because at least 1 field must be visible).
Sometimes, if you 'set screen updating to false' before beginning such an
operation via AppleScript, then setting it back to true when done, you can
save a lot of time and speed it up. Does that help in this circumstance?
('screen updating' is a property of the application, so should be done in a
tell app "Microsoft Excel" block without any internal tell blocks around
it.)
--
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