• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Excel 2004 - disable macro warning?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Excel 2004 - disable macro warning?


  • Subject: Re: Excel 2004 - disable macro warning?
  • From: Dave Balderstone <email@hidden>
  • Date: Tue, 14 Dec 2004 14:44:56 -0600


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).

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.

Thanks, Paul.

_______________________________________________
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


  • Follow-Ups:
    • Re: Excel 2004 - disable macro warning?
      • From: Paul Berkowitz <email@hidden>
References: 
 >Re: Excel 2004 - disable macro warning? (From: Paul Berkowitz <email@hidden>)

  • Prev by Date: Re: Just Spamm? Simple as that?
  • Next by Date: Re: Excel 2004 - disable macro warning?
  • Previous by thread: Re: Excel 2004 - disable macro warning?
  • Next by thread: Re: Excel 2004 - disable macro warning?
  • Index(es):
    • Date
    • Thread