{"id":111910,"date":"2021-08-02T13:36:00","date_gmt":"2021-08-02T10:36:00","guid":{"rendered":"https:\/\/howto.mediadoma.com\/?p=111910"},"modified":"2025-03-14T18:03:08","modified_gmt":"2025-03-14T15:03:08","slug":"vba-fel-400-vad-ar-det-och-hur-man-atgardar-det","status":"publish","type":"post","link":"https:\/\/howto.mediadoma.com\/sv\/vba-fel-400-vad-ar-det-och-hur-man-atgardar-det\/","title":{"rendered":"VBA-fel 400: Vad \u00e4r det och hur man \u00e5tg\u00e4rdar det"},"content":{"rendered":"

Vissa anv\u00e4ndare verkar f\u00e5 ett VBA-fel 400 n\u00e4r de f\u00f6rs\u00f6ker k\u00f6ra sin makro i Excel<\/a>. Det finns inga ytterligare indikationer bara en ruta med en OK-knapp.<\/p>\n

Hur som helst, oroa dig inte, vi har n\u00e5gra enkla l\u00f6sningar f\u00f6r dig. Vi f\u00f6resl\u00e5r att du f\u00f6ljer stegen som n\u00e4mns i den h\u00e4r artikeln i den presenterade ordningen. F\u00f6rhoppningsvis hj\u00e4lper de dig att l\u00f6sa ditt problem.<\/p>\n

Hur kan jag l\u00f6sa fel 400 i Excel?<\/h2>\n

1 Flytta dina makron till en ny modul<\/h3>\n

\"VBA-fel<\/a><\/p>\n

    \n
  1. F\u00f6r att skapa en ny modul, g\u00e5 till Verktyg-<\/strong> menyn.<\/li>\n
  2. Klicka p\u00e5 Makro – Visual Basic Editor.<\/strong><\/li>\n
  3. I VBA klickar du p\u00e5 Modul<\/strong> p\u00e5 menyn Infoga.<\/strong><\/li>\n
  4. Klistra in den VBA-kod<\/strong> som du vill anv\u00e4nda.<\/li>\n
  5. Klicka p\u00e5 Spara globalt<\/strong> i Arkiv-<\/strong> menyn.<\/strong><\/li>\n
  6. Se till att ta bort<\/strong> den gamla modulen.<\/li>\n<\/ol>\n
    \n

    2 Aktivera den betrodda \u00e5tkomsten till VBA<\/h3>\n

    \"VBA-fel<\/a><\/p>\n

      \n
    1. G\u00e5 till fliken Utvecklare<\/strong> (Om detta inte \u00e4r tillg\u00e4ngligt klickar Arkiv<\/strong> > Alternativ<\/strong> > Anpassa Ribbon><\/strong> v\u00e4lja den Developer<\/strong> kryssrutan).<\/li>\n
    2. I kodgruppen –<\/strong> g\u00e5 till fliken Utvecklare.<\/strong><\/li>\n
    3. Klicka p\u00e5 Makros\u00e4kerhet.<\/strong><\/li>\n
    4. V\u00e4lj Makroinst\u00e4llningar f\u00f6r utvecklare<\/strong> – v\u00e4lj P\u00e5litlig \u00e5tkomst till VBA-projektet.<\/strong><\/li>\n<\/ol>\n
      \n

      3 Kontrollera din kod<\/h3>\n

      \"VBA-fel<\/a><\/p>\n

      Se till att alltid kontrollera din kod f\u00f6r eventuella misstag. Dessutom \u00e4r det ocks\u00e5 n\u00f6dv\u00e4ndigt att s\u00f6ka efter makrokorruption.<\/p>\n

      \n

      Det handlar om det. Vi hoppas att om du g\u00f6r detta bekr\u00e4ftade l\u00f6sningar kommer ditt VBA 400-fel att \u00e5tg\u00e4rdas. Om du har andra bekr\u00e4ftade f\u00f6rslag, v\u00e4nligen meddela oss i en kommentar nedan.<\/p>\n

      Inspelningsk\u00e4lla: windowsreport.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"

      Om du vill l\u00f6sa ditt VBA-fel 400 kan du testa v\u00e5ra l\u00f6sningar. Att flytta din makro till en ny modul hj\u00e4lper vanligtvis.<\/p>\n","protected":false},"author":1,"featured_media":35445,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[1317],"tags":[3063],"class_list":["post-111910","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-atgarda-korrupta-filer","tag-affiai-sv"],"_links":{"self":[{"href":"https:\/\/howto.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts\/111910","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howto.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howto.mediadoma.com\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howto.mediadoma.com\/sv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howto.mediadoma.com\/sv\/wp-json\/wp\/v2\/comments?post=111910"}],"version-history":[{"count":1,"href":"https:\/\/howto.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts\/111910\/revisions"}],"predecessor-version":[{"id":311384,"href":"https:\/\/howto.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts\/111910\/revisions\/311384"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/howto.mediadoma.com\/sv\/wp-json\/wp\/v2\/media\/35445"}],"wp:attachment":[{"href":"https:\/\/howto.mediadoma.com\/sv\/wp-json\/wp\/v2\/media?parent=111910"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howto.mediadoma.com\/sv\/wp-json\/wp\/v2\/categories?post=111910"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howto.mediadoma.com\/sv\/wp-json\/wp\/v2\/tags?post=111910"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}