Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Security (Excel 2000)

    Hi all,

    I have a workbook that I would like to distribute to some users within the company, how do I enable the security so it doesn't see the workbook as macro?

    Thanks,
    Darryl.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Security (Excel 2000)

    Do you mean that you want to avoid the macro security warning? You'd have to digitally sign the workbook. The users would have to confirm once that they trust the certificate, after that they wouldn't get the macro security warning any more. See Description of digital certificates. You can get a certificate from companies such as VeriSign, Inc. or Thawte, if your company doesn't have one yet.

    If you meant something else, please explain.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Security (Excel 2000)

    With Office 2000, creating your own digital cert will also work (that changd with XP).
    Look for a file called selfcert.exe in your Office folder. Run it and enter the details.
    Then open your project file, open the VBE and choose Tools, Digital signature.
    Click Choose and select one from the list. OK twice and save your file.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Security (Excel 2000)

    Thank you all

Posting Permissions

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