{"id":785,"date":"2019-12-10T18:37:00","date_gmt":"2019-12-10T17:37:00","guid":{"rendered":"https:\/\/www.sw-stein.de\/sw\/?page_id=785"},"modified":"2023-11-01T13:53:38","modified_gmt":"2023-11-01T12:53:38","slug":"visual-basic-for-applications-vba","status":"publish","type":"page","link":"https:\/\/www.sw-stein.de\/sw\/medizinische-informatik\/visual-basic-for-applications-vba\/","title":{"rendered":"Visual Basic for Applications (VBA)"},"content":{"rendered":"<div class=\"shariff shariff-align-left shariff-widget-align-left\" style=\"display:none\" data-services=\"facebook\" data-url=\"https:\/\/www.sw-stein.de\/sw\/medizinische-informatik\/visual-basic-for-applications-vba\/\" data-timestamp=\"1698846818\" data-hidezero=\"1\" data-backendurl=\"https:\/\/www.sw-stein.de\/sw\/wp-json\/shariff\/v1\/share_counts?\"><ul class=\"shariff-buttons theme-round orientation-horizontal buttonsize-large\"><li class=\"shariff-button mailto shariff-nocustomcolor\" style=\"background-color:#a8a8a8;border-radius:43%\"><a href=\"mailto:?body=https%3A%2F%2Fwww.sw-stein.de%2Fsw%2Fmedizinische-informatik%2Fvisual-basic-for-applications-vba%2F&subject=Visual%20Basic%20for%20Applications%20%28VBA%29\" title=\"Per E-Mail versenden\" aria-label=\"Per E-Mail versenden\" role=\"button\" rel=\"noopener nofollow\" class=\"shariff-link\" style=\";border-radius:43%; background-color:#999; color:#fff\"><span class=\"shariff-icon\" style=\"\"><svg width=\"32px\" height=\"20px\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 32 32\"><path fill=\"#999\" d=\"M32 12.7v14.2q0 1.2-0.8 2t-2 0.9h-26.3q-1.2 0-2-0.9t-0.8-2v-14.2q0.8 0.9 1.8 1.6 6.5 4.4 8.9 6.1 1 0.8 1.6 1.2t1.7 0.9 2 0.4h0.1q0.9 0 2-0.4t1.7-0.9 1.6-1.2q3-2.2 8.9-6.1 1-0.7 1.8-1.6zM32 7.4q0 1.4-0.9 2.7t-2.2 2.2q-6.7 4.7-8.4 5.8-0.2 0.1-0.7 0.5t-1 0.7-0.9 0.6-1.1 0.5-0.9 0.2h-0.1q-0.4 0-0.9-0.2t-1.1-0.5-0.9-0.6-1-0.7-0.7-0.5q-1.6-1.1-4.7-3.2t-3.6-2.6q-1.1-0.7-2.1-2t-1-2.5q0-1.4 0.7-2.3t2.1-0.9h26.3q1.2 0 2 0.8t0.9 2z\"\/><\/svg><\/span><\/a><\/li><li class=\"shariff-button printer shariff-nocustomcolor\" style=\"background-color:#a8a8a8;border-radius:43%\"><a href=\"javascript:window.print()\" title=\"drucken\" aria-label=\"drucken\" role=\"button\" rel=\"noopener nofollow\" class=\"shariff-link\" style=\";border-radius:43%; background-color:#999; color:#fff\"><span class=\"shariff-icon\" style=\"\"><svg width=\"32px\" height=\"20px\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 30 32\"><path fill=\"#999\" d=\"M6.8 27.4h16v-4.6h-16v4.6zM6.8 16h16v-6.8h-2.8q-0.7 0-1.2-0.5t-0.5-1.2v-2.8h-11.4v11.4zM27.4 17.2q0-0.5-0.3-0.8t-0.8-0.4-0.8 0.4-0.3 0.8 0.3 0.8 0.8 0.3 0.8-0.3 0.3-0.8zM29.7 17.2v7.4q0 0.2-0.2 0.4t-0.4 0.2h-4v2.8q0 0.7-0.5 1.2t-1.2 0.5h-17.2q-0.7 0-1.2-0.5t-0.5-1.2v-2.8h-4q-0.2 0-0.4-0.2t-0.2-0.4v-7.4q0-1.4 1-2.4t2.4-1h1.2v-9.7q0-0.7 0.5-1.2t1.2-0.5h12q0.7 0 1.6 0.4t1.3 0.8l2.7 2.7q0.5 0.5 0.9 1.4t0.4 1.6v4.6h1.1q1.4 0 2.4 1t1 2.4z\"\/><\/svg><\/span><\/a><\/li><li class=\"shariff-button telegram shariff-nocustomcolor\" style=\"background-color:#4084A6;border-radius:43%\"><a href=\"https:\/\/telegram.me\/share\/url?url=https%3A%2F%2Fwww.sw-stein.de%2Fsw%2Fmedizinische-informatik%2Fvisual-basic-for-applications-vba%2F&text=Visual%20Basic%20for%20Applications%20%28VBA%29\" title=\"Bei Telegram teilen\" aria-label=\"Bei Telegram teilen\" role=\"button\" rel=\"noopener nofollow\" class=\"shariff-link\" style=\";border-radius:43%; background-color:#0088cc; color:#fff\" target=\"_blank\"><span class=\"shariff-icon\" style=\"\"><svg width=\"32px\" height=\"20px\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 32 32\"><path fill=\"#0088cc\" d=\"M30.8 6.5l-4.5 21.4c-.3 1.5-1.2 1.9-2.5 1.2L16.9 24l-3.3 3.2c-.4.4-.7.7-1.4.7l.5-7L25.5 9.2c.6-.5-.1-.8-.9-.3l-15.8 10L2 16.7c-1.5-.5-1.5-1.5.3-2.2L28.9 4.3c1.3-.5 2.3.3 1.9 2.2z\"\/><\/svg><\/span><\/a><\/li><li class=\"shariff-button whatsapp shariff-nocustomcolor shariff-mobile\" style=\"background-color:#5cbe4a;border-radius:43%\"><a href=\"https:\/\/api.whatsapp.com\/send?text=https%3A%2F%2Fwww.sw-stein.de%2Fsw%2Fmedizinische-informatik%2Fvisual-basic-for-applications-vba%2F%20Visual%20Basic%20for%20Applications%20%28VBA%29\" title=\"Bei Whatsapp teilen\" aria-label=\"Bei Whatsapp teilen\" role=\"button\" rel=\"noopener nofollow\" class=\"shariff-link\" style=\";border-radius:43%; background-color:#34af23; color:#fff\" target=\"_blank\"><span class=\"shariff-icon\" style=\"\"><svg width=\"32px\" height=\"20px\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 32 32\"><path fill=\"#34af23\" d=\"M17.6 17.4q0.2 0 1.7 0.8t1.6 0.9q0 0.1 0 0.3 0 0.6-0.3 1.4-0.3 0.7-1.3 1.2t-1.8 0.5q-1 0-3.4-1.1-1.7-0.8-3-2.1t-2.6-3.3q-1.3-1.9-1.3-3.5v-0.1q0.1-1.6 1.3-2.8 0.4-0.4 0.9-0.4 0.1 0 0.3 0t0.3 0q0.3 0 0.5 0.1t0.3 0.5q0.1 0.4 0.6 1.6t0.4 1.3q0 0.4-0.6 1t-0.6 0.8q0 0.1 0.1 0.3 0.6 1.3 1.8 2.4 1 0.9 2.7 1.8 0.2 0.1 0.4 0.1 0.3 0 1-0.9t0.9-0.9zM14 26.9q2.3 0 4.3-0.9t3.6-2.4 2.4-3.6 0.9-4.3-0.9-4.3-2.4-3.6-3.6-2.4-4.3-0.9-4.3 0.9-3.6 2.4-2.4 3.6-0.9 4.3q0 3.6 2.1 6.6l-1.4 4.2 4.3-1.4q2.8 1.9 6.2 1.9zM14 2.2q2.7 0 5.2 1.1t4.3 2.9 2.9 4.3 1.1 5.2-1.1 5.2-2.9 4.3-4.3 2.9-5.2 1.1q-3.5 0-6.5-1.7l-7.4 2.4 2.4-7.2q-1.9-3.2-1.9-6.9 0-2.7 1.1-5.2t2.9-4.3 4.3-2.9 5.2-1.1z\"\/><\/svg><\/span><\/a><\/li><li class=\"shariff-button threema shariff-nocustomcolor shariff-mobile\" style=\"background-color:#4fbc24;border-radius:43%\"><a href=\"threema:\/\/compose?text=Visual%20Basic%20for%20Applications%20%28VBA%29%20https%3A%2F%2Fwww.sw-stein.de%2Fsw%2Fmedizinische-informatik%2Fvisual-basic-for-applications-vba%2F\" title=\"Bei Threema teilen\" aria-label=\"Bei Threema teilen\" role=\"button\" rel=\"noopener nofollow\" class=\"shariff-link\" style=\";border-radius:43%; background-color:#1f1f1f; color:#fff\" target=\"_blank\"><span class=\"shariff-icon\" style=\"\"><svg width=\"32px\" height=\"20px\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 32 32\"><path fill=\"#1f1f1f\" d=\"M30.8 10.9c-0.3-1.4-0.9-2.6-1.8-3.8-2-2.6-5.5-4.5-9.4-5.2-1.3-0.2-1.9-0.3-3.5-0.3s-2.2 0-3.5 0.3c-4 0.7-7.4 2.6-9.4 5.2-0.9 1.2-1.5 2.4-1.8 3.8-0.1 0.5-0.2 1.2-0.2 1.6 0 0.4 0.1 1.1 0.2 1.6 0.4 1.9 1.3 3.4 2.9 5 0.8 0.8 0.8 0.8 0.7 1.3 0 0.6-0.5 1.6-1.7 3.6-0.3 0.5-0.5 0.9-0.5 0.9 0 0.1 0.1 0.1 0.5 0 0.8-0.2 2.3-0.6 5.6-1.6 1.1-0.3 1.3-0.4 2.3-0.4 0.8 0 1.1 0 2.3 0.2 1.5 0.2 3.5 0.2 4.9 0 5.1-0.6 9.3-2.9 11.4-6.3 0.5-0.9 0.9-1.8 1.1-2.8 0.1-0.5 0.2-1.1 0.2-1.6 0-0.7-0.1-1.1-0.2-1.6-0.3-1.4 0.1 0.5 0 0zM20.6 17.3c0 0.4-0.4 0.8-0.8 0.8h-7.7c-0.4 0-0.8-0.4-0.8-0.8v-4.6c0-0.4 0.4-0.8 0.8-0.8h0.2l0-1.6c0-0.9 0-1.8 0.1-2 0.1-0.6 0.6-1.2 1.1-1.7s1.1-0.7 1.9-0.8c1.8-0.3 3.7 0.7 4.2 2.2 0.1 0.3 0.1 0.7 0.1 2.1v0 1.7h0.1c0.4 0 0.8 0.4 0.8 0.8v4.6zM15.6 7.3c-0.5 0.1-0.8 0.3-1.2 0.6s-0.6 0.8-0.7 1.3c0 0.2 0 0.8 0 1.5l0 1.2h4.6v-1.3c0-1 0-1.4-0.1-1.6-0.3-1.1-1.5-1.9-2.6-1.7zM25.8 28.2c0 1.2-1 2.2-2.1 2.2s-2.1-1-2.1-2.1c0-1.2 1-2.1 2.2-2.1s2.2 1 2.2 2.2zM18.1 28.2c0 1.2-1 2.2-2.1 2.2s-2.1-1-2.1-2.1c0-1.2 1-2.1 2.2-2.1s2.2 1 2.2 2.2zM10.4 28.2c0 1.2-1 2.2-2.1 2.2s-2.1-1-2.1-2.1c0-1.2 1-2.1 2.2-2.1s2.2 1 2.2 2.2z\"\/><\/svg><\/span><\/a><\/li><li class=\"shariff-button sms shariff-nocustomcolor shariff-mobile\" style=\"background-color:#d7d9d8;border-radius:43%\"><a href=\"sms:?&body=https%3A%2F%2Fwww.sw-stein.de%2Fsw%2Fmedizinische-informatik%2Fvisual-basic-for-applications-vba%2F\" title=\"Per SMS teilen\" aria-label=\"Per SMS teilen\" role=\"button\" rel=\"noopener nofollow\" class=\"shariff-link\" style=\";border-radius:43%; background-color:#a1e877; color:#fff\" target=\"_blank\"><span class=\"shariff-icon\" style=\"\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"510\" height=\"510\" viewBox=\"0 0 510 510\"><path fill=\"#a1e877\" d=\"M459 0H51C23 0 0 23 0 51v459l102-102h357c28.1 0 51-22.9 51-51V51C510 23 487.1 0 459 0zM178.5 229.5h-51v-51h51V229.5zM280.5 229.5h-51v-51h51V229.5zM382.5 229.5h-51v-51h51V229.5z\"\/><\/svg><\/span><\/a><\/li><li class=\"shariff-button rss shariff-nocustomcolor\" style=\"background-color:#ff8c00;border-radius:43%\"><a href=\"https:\/\/www.sw-stein.de\/sw\/feed\/rss\/\" title=\"RSS-feed\" aria-label=\"RSS-feed\" role=\"button\" class=\"shariff-link\" style=\";border-radius:43%; background-color:#fe9312; color:#fff\" target=\"_blank\"><span class=\"shariff-icon\" style=\"\"><svg width=\"32px\" height=\"20px\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 32 32\"><path fill=\"#fe9312\" d=\"M4.3 23.5c-2.3 0-4.3 1.9-4.3 4.3 0 2.3 1.9 4.2 4.3 4.2 2.4 0 4.3-1.9 4.3-4.2 0-2.3-1.9-4.3-4.3-4.3zM0 10.9v6.1c4 0 7.7 1.6 10.6 4.4 2.8 2.8 4.4 6.6 4.4 10.6h6.2c0-11.7-9.5-21.1-21.1-21.1zM0 0v6.1c14.2 0 25.8 11.6 25.8 25.9h6.2c0-17.6-14.4-32-32-32z\"\/><\/svg><\/span><\/a><\/li><li class=\"shariff-button pocket shariff-nocustomcolor\" style=\"background-color:#444;border-radius:43%\"><a href=\"https:\/\/getpocket.com\/save?url=https%3A%2F%2Fwww.sw-stein.de%2Fsw%2Fmedizinische-informatik%2Fvisual-basic-for-applications-vba%2F&title=Visual%20Basic%20for%20Applications%20%28VBA%29\" title=\"Bei Pocket speichern\" aria-label=\"Bei Pocket speichern\" role=\"button\" rel=\"noopener nofollow\" class=\"shariff-link\" style=\";border-radius:43%; background-color:#ff0000; color:#fff\" target=\"_blank\"><span class=\"shariff-icon\" style=\"\"><svg width=\"32px\" height=\"20px\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 27 28\"><path fill=\"#ff0000\" d=\"M24.5 2q1 0 1.7 0.7t0.7 1.7v8.1q0 2.8-1.1 5.3t-2.9 4.3-4.3 2.9-5.2 1.1q-2.7 0-5.2-1.1t-4.3-2.9-2.9-4.3-1.1-5.2v-8.1q0-1 0.7-1.7t1.7-0.7h22zM13.5 18.6q0.7 0 1.3-0.5l6.3-6.1q0.6-0.5 0.6-1.3 0-0.8-0.5-1.3t-1.3-0.5q-0.7 0-1.3 0.5l-5 4.8-5-4.8q-0.5-0.5-1.3-0.5-0.8 0-1.3 0.5t-0.5 1.3q0 0.8 0.6 1.3l6.3 6.1q0.5 0.5 1.3 0.5z\"\/><\/svg><\/span><\/a><\/li><li class=\"shariff-button facebook shariff-nocustomcolor\" style=\"background-color:#4273c8;border-radius:43%\"><a href=\"https:\/\/www.facebook.com\/sharer\/sharer.php?u=https%3A%2F%2Fwww.sw-stein.de%2Fsw%2Fmedizinische-informatik%2Fvisual-basic-for-applications-vba%2F\" title=\"Bei Facebook teilen\" aria-label=\"Bei Facebook teilen\" role=\"button\" rel=\"nofollow\" class=\"shariff-link\" style=\";border-radius:43%; background-color:#3b5998; color:#fff\" target=\"_blank\"><span class=\"shariff-icon\" style=\"\"><svg width=\"32px\" height=\"20px\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 18 32\"><path fill=\"#3b5998\" d=\"M17.1 0.2v4.7h-2.8q-1.5 0-2.1 0.6t-0.5 1.9v3.4h5.2l-0.7 5.3h-4.5v13.6h-5.5v-13.6h-4.5v-5.3h4.5v-3.9q0-3.3 1.9-5.2t5-1.8q2.6 0 4.1 0.2z\"\/><\/svg><\/span><\/a><\/li><li class=\"shariff-button linkedin shariff-nocustomcolor\" style=\"background-color:#1488bf;border-radius:43%\"><a href=\"https:\/\/www.linkedin.com\/sharing\/share-offsite\/?url=https%3A%2F%2Fwww.sw-stein.de%2Fsw%2Fmedizinische-informatik%2Fvisual-basic-for-applications-vba%2F\" title=\"Bei LinkedIn teilen\" aria-label=\"Bei LinkedIn teilen\" role=\"button\" rel=\"noopener nofollow\" class=\"shariff-link\" style=\";border-radius:43%; background-color:#0077b5; color:#fff\" target=\"_blank\"><span class=\"shariff-icon\" style=\"\"><svg width=\"32px\" height=\"20px\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 27 32\"><path fill=\"#0077b5\" d=\"M6.2 11.2v17.7h-5.9v-17.7h5.9zM6.6 5.7q0 1.3-0.9 2.2t-2.4 0.9h0q-1.5 0-2.4-0.9t-0.9-2.2 0.9-2.2 2.4-0.9 2.4 0.9 0.9 2.2zM27.4 18.7v10.1h-5.9v-9.5q0-1.9-0.7-2.9t-2.3-1.1q-1.1 0-1.9 0.6t-1.2 1.5q-0.2 0.5-0.2 1.4v9.9h-5.9q0-7.1 0-11.6t0-5.3l0-0.9h5.9v2.6h0q0.4-0.6 0.7-1t1-0.9 1.6-0.8 2-0.3q3 0 4.9 2t1.9 6z\"\/><\/svg><\/span><\/a><\/li><li class=\"shariff-button xing shariff-nocustomcolor\" style=\"background-color:#29888a;border-radius:43%\"><a href=\"https:\/\/www.xing.com\/spi\/shares\/new?url=https%3A%2F%2Fwww.sw-stein.de%2Fsw%2Fmedizinische-informatik%2Fvisual-basic-for-applications-vba%2F\" title=\"Bei XING teilen\" aria-label=\"Bei XING teilen\" role=\"button\" rel=\"noopener nofollow\" class=\"shariff-link\" style=\";border-radius:43%; background-color:#126567; color:#fff\" target=\"_blank\"><span class=\"shariff-icon\" style=\"\"><svg width=\"32px\" height=\"20px\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 25 32\"><path fill=\"#126567\" d=\"M10.7 11.9q-0.2 0.3-4.6 8.2-0.5 0.8-1.2 0.8h-4.3q-0.4 0-0.5-0.3t0-0.6l4.5-8q0 0 0 0l-2.9-5q-0.2-0.4 0-0.7 0.2-0.3 0.5-0.3h4.3q0.7 0 1.2 0.8zM25.1 0.4q0.2 0.3 0 0.7l-9.4 16.7 6 11q0.2 0.4 0 0.6-0.2 0.3-0.6 0.3h-4.3q-0.7 0-1.2-0.8l-6-11.1q0.3-0.6 9.5-16.8 0.4-0.8 1.2-0.8h4.3q0.4 0 0.5 0.3z\"\/><\/svg><\/span><\/a><\/li><li class=\"shariff-button twitter shariff-nocustomcolor\" style=\"background-color:#595959;border-radius:43%\"><a href=\"https:\/\/twitter.com\/share?url=https%3A%2F%2Fwww.sw-stein.de%2Fsw%2Fmedizinische-informatik%2Fvisual-basic-for-applications-vba%2F&text=Visual%20Basic%20for%20Applications%20%28VBA%29\" title=\"Bei X teilen\" aria-label=\"Bei X teilen\" role=\"button\" rel=\"noopener nofollow\" class=\"shariff-link\" style=\";border-radius:43%; background-color:#000; color:#fff\" target=\"_blank\"><span class=\"shariff-icon\" style=\"\"><svg width=\"32px\" height=\"20px\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\"><path fill=\"#000\" d=\"M14.258 10.152L23.176 0h-2.113l-7.747 8.813L7.133 0H0l9.352 13.328L0 23.973h2.113l8.176-9.309 6.531 9.309h7.133zm-2.895 3.293l-.949-1.328L2.875 1.56h3.246l6.086 8.523.945 1.328 7.91 11.078h-3.246zm0 0\"\/><\/svg><\/span><\/a><\/li><\/ul><\/div>\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">Automatisierung von aufw\u00e4ndigen wiederkehrenden Prozessen in der Datenverarbeitung in Microsoft Office mittels <strong>Visual Basic for Applications (VBA)<\/strong>: Schwerpunkt auf Microsoft Excel, Word und Access. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Erfahrung als Makroverantwortlicher<\/strong> zur Administration der digitalen Zertifikate zum Schutz vor  Ransomware und der Ausf\u00fchrung nicht autorisierter Makros<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><a href=\"https:\/\/www.sw-stein.de\/sw\/medizinische-informatik\/microsoft-office-ui-customization\/\">User Interface (UI) Customization von Microsoft Office<\/a><\/strong><\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"746\" height=\"348\" src=\"https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2019\/12\/vba_makros_sw.png\" alt=\"Visual Basic for Applications (VBA) - Editor in Microsoft Excel\" class=\"wp-image-790\" srcset=\"https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2019\/12\/vba_makros_sw.png 746w, https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2019\/12\/vba_makros_sw-300x140.png 300w\" sizes=\"auto, (max-width: 746px) 100vw, 746px\" \/><figcaption class=\"wp-element-caption\">Visual Basic for Applications (VBA) &#8211; Editor in Microsoft Excel<\/figcaption><\/figure>\n<\/div>\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Signierung von VBA-Projekten<\/strong> mit mehreren Modulen mit Zertifikaten (<strong>Digitale Signatur<\/strong>)<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1038\" height=\"627\" src=\"https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2019\/12\/vba_signiertes_makro_cert.png\" alt=\"Signiertes Modul in VBA\" class=\"wp-image-791\" srcset=\"https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2019\/12\/vba_signiertes_makro_cert.png 1038w, https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2019\/12\/vba_signiertes_makro_cert-300x181.png 300w, https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2019\/12\/vba_signiertes_makro_cert-1024x619.png 1024w, https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2019\/12\/vba_signiertes_makro_cert-768x464.png 768w\" sizes=\"auto, (max-width: 1038px) 100vw, 1038px\" \/><figcaption class=\"wp-element-caption\">Signiertes Modul in einem VBA-Projekt (Microsoft Excel)<\/figcaption><\/figure>\n<\/div>\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">Um die Ausf\u00fchrung von nicht signierten Makros auszuschlie\u00dfen und damit das Sicherheitslevel zu erh\u00f6hen, setze ich gerne eine Gruppenrichtlinie ein. Exemplarisch ist die Einstellung in Microsoft Excel vordefiniert und kann von einzelnen Anwendern nicht mehr ge\u00e4ndert werden (&#8222;ausgegraute Eintr\u00e4ge&#8220;):<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"936\" height=\"678\" src=\"https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2019\/12\/makros_deaktivieren_ohne_signatur_excel_msoffice.png\" alt=\"Deaktivierung nicht signierter Makros (Gruppenrichtlinie)\" class=\"wp-image-815\" srcset=\"https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2019\/12\/makros_deaktivieren_ohne_signatur_excel_msoffice.png 936w, https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2019\/12\/makros_deaktivieren_ohne_signatur_excel_msoffice-300x217.png 300w, https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2019\/12\/makros_deaktivieren_ohne_signatur_excel_msoffice-700x507.png 700w, https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2019\/12\/makros_deaktivieren_ohne_signatur_excel_msoffice-768x556.png 768w\" sizes=\"auto, (max-width: 936px) 100vw, 936px\" \/><figcaption class=\"wp-element-caption\">Deaktivierung nicht signierter Makros (Gruppenrichtlinie)<\/figcaption><\/figure>\n<\/div>\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1152\" height=\"596\" src=\"https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2020\/01\/mmc_windows_zertifikate.png\" alt=\"MMC: Eigene Zertifikate (Codesignierung und Clientauthentifizierung)\" class=\"wp-image-1050\" srcset=\"https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2020\/01\/mmc_windows_zertifikate.png 1152w, https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2020\/01\/mmc_windows_zertifikate-300x155.png 300w, https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2020\/01\/mmc_windows_zertifikate-700x362.png 700w, https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2020\/01\/mmc_windows_zertifikate-768x397.png 768w\" sizes=\"auto, (max-width: 1152px) 100vw, 1152px\" \/><figcaption class=\"wp-element-caption\">MMC: Eigene Zertifikate (Codesignierung und Clientauthentifizierung)<\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"383\" height=\"284\" src=\"https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2020\/03\/win10_import_zertifikat_erfolgreich.png\" alt=\"Zertifikatimport\" class=\"wp-image-1124\" srcset=\"https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2020\/03\/win10_import_zertifikat_erfolgreich.png 383w, https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2020\/03\/win10_import_zertifikat_erfolgreich-300x222.png 300w\" sizes=\"auto, (max-width: 383px) 100vw, 383px\" \/><figcaption class=\"wp-element-caption\">Zertifikatimport<\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"383\" src=\"https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2020\/03\/win10_o2013_keine_zert_vba.png\" alt=\"Keine digitalen Signaturzertifikate (VBA)\" class=\"wp-image-1123\" srcset=\"https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2020\/03\/win10_o2013_keine_zert_vba.png 940w, https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2020\/03\/win10_o2013_keine_zert_vba-300x122.png 300w, https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2020\/03\/win10_o2013_keine_zert_vba-700x285.png 700w, https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2020\/03\/win10_o2013_keine_zert_vba-768x313.png 768w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><figcaption class=\"wp-element-caption\">Keine digitalen Signaturzertifikate (VBA)<\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"547\" height=\"375\" src=\"https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2020\/01\/zertifikate_dr_wagner_vba_projekt.png\" alt=\"Zertifikatsauswahl in Microsoft Office zur digitalen Signierung eines VBA-Projektes\" class=\"wp-image-993\" srcset=\"https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2020\/01\/zertifikate_dr_wagner_vba_projekt.png 547w, https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2020\/01\/zertifikate_dr_wagner_vba_projekt-300x206.png 300w\" sizes=\"auto, (max-width: 547px) 100vw, 547px\" \/><figcaption class=\"wp-element-caption\">Zertifikatsauswahl in Microsoft Office zur digitalen Signierung eines VBA-Projektes<\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"456\" height=\"336\" src=\"https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2020\/03\/win10_zert_mac_auswahl_vba_editor.png\" alt=\"Zertifikatsauswahl zur digitalen Signierung eines VBA-Projektes\" class=\"wp-image-1122\" srcset=\"https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2020\/03\/win10_zert_mac_auswahl_vba_editor.png 456w, https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2020\/03\/win10_zert_mac_auswahl_vba_editor-300x221.png 300w\" sizes=\"auto, (max-width: 456px) 100vw, 456px\" \/><figcaption class=\"wp-element-caption\">Zertifikatsauswahl zur digitalen Signierung eines VBA-Projektes<\/figcaption><\/figure>\n<\/div>\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"486\" height=\"636\" src=\"https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2020\/01\/eigenes_zertifikat_office.png\" alt=\"Import selbst erstellter Zertifikate und privater Schl\u00fcssel (Windows)\" class=\"wp-image-994\" srcset=\"https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2020\/01\/eigenes_zertifikat_office.png 486w, https:\/\/www.sw-stein.de\/sw\/wp-content\/uploads\/2020\/01\/eigenes_zertifikat_office-229x300.png 229w\" sizes=\"auto, (max-width: 486px) 100vw, 486px\" \/><figcaption class=\"wp-element-caption\">Import selbst erstellter Zertifikate und privater Schl\u00fcssel (Windows)<\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.sw-stein.de\/sw\/sws\/sws.php\" alt=\"\" width=\"0\" height=\"0\">\n","protected":false},"excerpt":{"rendered":"<p>Automatisierung von aufw\u00e4ndigen wiederkehrenden Prozessen in der Datenverarbeitung in Microsoft Office mittels Visual Basic for Applications (VBA): Schwerpunkt auf Microsoft Excel, Word und Access. Erfahrung als Makroverantwortlicher zur Administration der digitalen Zertifikate zum Schutz vor Ransomware und der Ausf\u00fchrung nicht autorisierter Makros User Interface (UI) Customization von Microsoft Office Signierung von VBA-Projekten mit mehreren Modulen mit Zertifikaten (Digitale Signatur) Um die Ausf\u00fchrung von nicht signierten Makros auszuschlie\u00dfen und damit das Sicherheitslevel zu erh\u00f6hen, setze ich gerne eine Gruppenrichtlinie ein. Exemplarisch ist die Einstellung in Microsoft Excel vordefiniert und kann von einzelnen Anwendern nicht mehr ge\u00e4ndert werden (&#8222;ausgegraute Eintr\u00e4ge&#8220;):<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":144,"menu_order":4,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_metis_text_type":"standard","_metis_text_length":1333,"_post_count":0,"footnotes":""},"class_list":["post-785","page","type-page","status-publish","hentry"],"public_identification_id":"e1e27faf4e924723a78bf883048c3b8e","private_identification_id":"69881d2d718b4bc6a5079abf83279129","_links":{"self":[{"href":"https:\/\/www.sw-stein.de\/sw\/wp-json\/wp\/v2\/pages\/785","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sw-stein.de\/sw\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sw-stein.de\/sw\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sw-stein.de\/sw\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sw-stein.de\/sw\/wp-json\/wp\/v2\/comments?post=785"}],"version-history":[{"count":10,"href":"https:\/\/www.sw-stein.de\/sw\/wp-json\/wp\/v2\/pages\/785\/revisions"}],"predecessor-version":[{"id":2319,"href":"https:\/\/www.sw-stein.de\/sw\/wp-json\/wp\/v2\/pages\/785\/revisions\/2319"}],"up":[{"embeddable":true,"href":"https:\/\/www.sw-stein.de\/sw\/wp-json\/wp\/v2\/pages\/144"}],"wp:attachment":[{"href":"https:\/\/www.sw-stein.de\/sw\/wp-json\/wp\/v2\/media?parent=785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}