+ Reply to Thread
Results 1 to 2 of 2

Some Excel Macro Security Questions ( Digital Signing Excel Macros with Certificate )

  1. #1
    Registered User
    Join Date
    02-21-2022
    Location
    Germany
    MS-Off Ver
    2019
    Posts
    1

    Question Some Excel Macro Security Questions ( Digital Signing Excel Macros with Certificate )

    Hello ,

    We have to make our Macro Excel Dokuments safe and deside to sign all of our internal Macro Excel Dokuments .
    Works so far so good . But now i have some Questions .
    We create an GPO which only enables the Option "deactivate all Macros and allow only signed Macros"
    We rollout an Certificate in the Trusted Publishers .
    So now only signed Macro Excel Documents can used by an User which was signed and the USer has the right Certificate in his Certificate Store.


    1. When i now try as an User to Record an Macro then i become an message that it is not possible . Ok so far.
    BUT when an User opens developer Tools / VBA Editor , it is possible to change settings and safe it . But this is not nice because he then can change the Macro .
    Is there an Solution how we can deaktivate this Option ?

    2. When we remove the Certificate in the "Thrusted Publisher" Certificate Store then Excel brings the yellow Message "Document has an Macro insight - Do you want to activate this " because of we setup Excel in Thustcenter so that the Option "deactivate all Macros
    and allow only signed Macros". Thats not nice .

    Hope someone can answer this Questions .

    Michael

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Some Excel Macro Security Questions ( Digital Signing Excel Macros with Certificate )

    Excel security is notoriously weak, anyone that knows their way around VBA can get past it.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Digitally signing xlsm file - can't get Excel to recognise certificate.
    By XmisterIS in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-21-2014, 12:42 PM
  2. Replies: 0
    Last Post: 07-11-2012, 12:30 PM
  3. Replies: 5
    Last Post: 01-20-2011, 11:59 AM
  4. digital certificate questions
    By bluegirl01 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-25-2008, 03:48 PM
  5. [SOLVED] How to protect a excel sheet using Digital certificate
    By Sinu in forum Excel General
    Replies: 0
    Last Post: 01-06-2006, 12:20 PM
  6. [SOLVED] macro security & digital certificate
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-09-2005, 10:50 PM
  7. [SOLVED] digital certificate for my macros with SelfCert.exe
    By MVM in forum Excel General
    Replies: 1
    Last Post: 01-26-2005, 06:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1