Re: Excel 2004 - disable macro warning?
Re: Excel 2004 - disable macro warning?
- Subject: Re: Excel 2004 - disable macro warning?
- From: Paul Berkowitz <email@hidden>
- Date: Tue, 14 Dec 2004 13:41:25 -0800
On 12/14/04 12:44 PM, "Dave Balderstone" <email@hidden>
wrote:
>
> On Dec 14, 2004, at 2:17 PM, Paul Berkowitz wrote:
>
>> Does setting 'automation security' to false before opening that
>> document,
>> then setting it back to true (or to whatever it was before) afterwards,
>> help? This property is only available (or operational) in Excel 11.1.0
>> (i.e.
>> 2004 with SP1), as explained by the Excel 2004 AppleScript Reference
>> just
>> released yesterday.
>
> Setting it to false has no effect.
>
> Reading the reference, it appears to me that the automation security
> settings apply to documents being opened by a VB macro, rather than via
> AS. (Thanks for the link to thosereferences, BTW).
I think it may instead be related to alerts that appear when you run some
macros, rather than to to the alert that appears when you _open a document
containing macros.
>
> This project script will only be run once a month or so (creating Code
> 39 barcodes from roll lists provided by our paper mill for scanning
> into an inventory system) so I can just manually open the template and
> then trigger the script. I don't want to spend too much time on it.
If it were worth the time involved, an alternative would be to re-write the
macro as an AppleScript, remove the macro from the document, and run the
script instead. Unless it's an AutoExec macro or one that runs automatically
from a template in Excel's Startup folder when you open Excel, of course. I
don't think it can be the latter, because when you put a template there, the
macro alert does not appear. So maybe that's a solution? (It has to be in a
template to work.) That's in /Applications/Microsoft Office
2004/Office/Startup/Excel/.
--
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:
This email sent to email@hidden