Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Sep 2001
    Posts
    211
    Thanks
    32
    Thanked 0 Times in 0 Posts
    I have created several spreadsheets containing macros (with your help!). I always get the prompt to enable or disable them before the file will open. I don't understand how to fix the files so that prompt doesn't appear every time. Can you help?

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    What version of excel are you using?
    In 2007 you can put the files in a trusted location which is a file location where the files contained in that folder (and even its sub-folders if the option is chosen) will have their macros run without the warning appearing. You can set Excel to not display a macro warning and allow all macros to be run.

    You can find the settings by going to Excel Options / Trust Center / [Trust Center Settings...]
    Trusted Locations or Macro settings

  3. #3
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    Quote Originally Posted by mbarron View Post
    You can set Excel to not display a macro warning and allow all macros to be run.
    Take this option at your peril. If you do it will be to the delight of malicious coders.
    Regards
    Don

  4. #4
    3 Star Lounger
    Join Date
    Sep 2001
    Posts
    211
    Thanks
    32
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by mbarron View Post
    What version of excel are you using?
    In 2007 you can put the files in a trusted location which is a file location where the files contained in that folder (and even its sub-folders if the option is chosen) will have their macros run without the warning appearing. You can set Excel to not display a macro warning and allow all macros to be run.

    You can find the settings by going to Excel Options / Trust Center / [Trust Center Settings...]
    Trusted Locations or Macro settings
    I am running Excel 2002 right now

  5. #5
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by k32rem View Post
    I am running Excel 2002 right now
    You can set this as follows: (Although I would not recomend this!)

    Within Excel, select (on the menu bar): Tools | Options | Security (tab) | Macro Security (button [lower right]) and then set the security level to low.

    [attachment=87687:macrosecurity.GIF]

    Malicious code could be set-up to automatically execute upon opening a malicious file!! Use this with caution!

    Regards
    Nathan
    Attached Images Attached Images

  6. #6
    3 Star Lounger
    Join Date
    Sep 2001
    Posts
    211
    Thanks
    32
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by VegasNath View Post
    You can set this as follows: (Although I would not recomend this!)

    Within Excel, select (on the menu bar): Tools | Options | Security (tab) | Macro Security (button [lower right]) and then set the security level to low.

    [attachment=87687:macrosecurity.GIF]

    Malicious code could be set-up to automatically execute upon opening a malicious file!! Use this with caution!

    Regards
    Nathan
    Thanks!

  7. #7
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    If these are for personal use, you could use a digital signature
    and use SELFCERT.EXE to create a local digital signature.

    BUT if it is for multiple users at work you would have to get a proper Digital Signature.

    Have a look at http://office.microsoft.com/en-us/he...495551033.aspx

    and http://excel.tips.net/Pages/T003107_...or_Macros.html
    Andrew

  8. #8
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts
    Quote Originally Posted by AndrewKKWalker View Post
    BUT if it is for multiple users at work you would have to get a proper Digital Signature.
    Andrew you beat me to this answer.

    But I have a difference of opinion; as noted in your second link, when Macros in Modules digitally signed with a SelfCert-generated certificate are distributed, other users can elect to trust them or not, and if they elect to trust them, they do not get the warning. So an external certificate is not necessary, though I believe SelfCert is not as secure as an independent certificate.

    I'm interested in hearing more about distributability and SelfCert.

    Also, for the OP, in see these instructions for installing Selfcert.exe in Office XP http://msdn.microsoft.com/en-us/libr...dsvba_selfcert
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •