{"id":12054,"date":"2011-10-11T09:51:17","date_gmt":"2011-10-11T09:51:17","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=14"},"modified":"2022-08-02T21:44:43","modified_gmt":"2022-08-02T21:44:43","slug":"how-to-disableinvisible-horizontalvertical-scroll-bar","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/","title":{"rendered":"How to disable\/Invisible Horizontal\/Vertical Scroll Bar"},"content":{"rendered":"<p>While developing some Excel VBA based tools in Excel, you might find this useful when you want to disable or enable horizontal or vertical scrolling in excel automatically.<br \/>\nIt is very easy to disable the Horizontal or Vertical Scroll bar using the VBA code. They are self-explanatory by the way. So here you go:<\/p>\n<ul>\n<li><a href=\"#enable-horizontal-vertical-scroll-bar\">To enable\/visible Horizontal and Vertical Scroll Bar<\/a><\/li>\n<li><a href=\"#disable-horizontal-vertical-scroll-bar\"> To disable\/invisible Horizontal and Vertical Scroll Bar<\/a><\/li>\n<\/ul>\n<p><!--more--><br \/>\n<a name=\"enable-horizontal-vertical-scroll-bar\"><\/a><\/p>\n<h1>VBA code to Show Horizontal or Vertical Scroll bar<\/h1>\n<pre><code class=\"language-vbnet\">\r\nSub ScrollOn()\r\nWith ActiveWindow\r\n.DisplayHorizontalScrollBar=True\r\n.DisplayVerticalScrollBar=True\r\n.DisplayWorkbookTabs=True\r\nEnd With\r\n<\/code><\/pre>\n<p><a name=\"disable-horizontal-vertical-scroll-bar\"><\/a><\/p>\n<h1>VBA code to hide Horizontal or Vertical Scroll bar<\/h1>\n<pre><code class=\"language-vbnet\">\r\nSub ScrollOn()\r\nWith ActiveWindow\r\n.DisplayHorizontalScrollBar=False\r\n.DisplayVerticalScrollBar=False\r\n.DisplayWorkbookTabs=False\r\nEnd With\r\n<\/code><\/pre>\n<h1>How to Show\/Hide Scroll Bars without VBA Code<\/h1>\n<p>It is also possible to show or hide Scroll bars of Excel in Excel Options as well. I have written this below article to show how to achieve this manually :<\/p>\n<p><a href=\"\/excel\/2011\/11\/hide-horizontal-or-vertical-scroll-bar-in-excel-workbook\" target=\"_blank\" rel=\"noopener\">Hide\/Display Horizontal\/Vertical Bar in an Excel Workbook<\/a><\/p>\n<span class=\"et_bloom_bottom_trigger\"><\/span>","protected":false},"excerpt":{"rendered":"<p>While developing some Excel VBA based tools in Excel, you might find this useful when you want to disable or enable horizontal or vertical scrolling in excel automatically. It is very easy to disable the Horizontal or Vertical Scroll bar using the VBA code. They are self-explanatory by the way. So here you go: To [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":13931,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1246,1674],"tags":[],"class_list":["post-12054","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-macro","category-excel-macro-basics"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.5 (Yoast SEO v23.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to disable or hide scrollbars in Excel using Excel Macros-Horizontal\/Vertical Scrollbars<\/title>\n<meta name=\"description\" content=\"All about options to Hide horizontal or vertical scroll bars in Excel. VBA to hide horizontal or vertical scroll bars in excel. How to show hidden scroll bars in Excel\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to disable\/Invisible Horizontal\/Vertical Scroll Bar\" \/>\n<meta property=\"og:description\" content=\"All about options to Hide horizontal or vertical scroll bars in Excel. VBA to hide horizontal or vertical scroll bars in excel. How to show hidden scroll bars in Excel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/\" \/>\n<meta property=\"og:site_name\" content=\"Let&#039;s excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2011-10-11T09:51:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-02T21:44:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Show-hide-Scroll-Bar-2.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"538\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"How to disable\/Invisible Horizontal\/Vertical Scroll Bar\",\"datePublished\":\"2011-10-11T09:51:17+00:00\",\"dateModified\":\"2022-08-02T21:44:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/\"},\"wordCount\":144,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Show-hide-Scroll-Bar-2.jpg\",\"articleSection\":[\"Excel Macro\",\"Excel Macro Basics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/\",\"name\":\"How to disable or hide scrollbars in Excel using Excel Macros-Horizontal\/Vertical Scrollbars\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Show-hide-Scroll-Bar-2.jpg\",\"datePublished\":\"2011-10-11T09:51:17+00:00\",\"dateModified\":\"2022-08-02T21:44:43+00:00\",\"description\":\"All about options to Hide horizontal or vertical scroll bars in Excel. VBA to hide horizontal or vertical scroll bars in excel. How to show hidden scroll bars in Excel\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Show-hide-Scroll-Bar-2.jpg\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Show-hide-Scroll-Bar-2.jpg\",\"width\":800,\"height\":538},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro\",\"item\":\"https:\/\/vmlogger.com\/excel\/macro\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to disable\/Invisible Horizontal\/Vertical Scroll Bar\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let&#039;s excel in Excel\",\"description\":\"Let&#039;s share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to disable or hide scrollbars in Excel using Excel Macros-Horizontal\/Vertical Scrollbars","description":"All about options to Hide horizontal or vertical scroll bars in Excel. VBA to hide horizontal or vertical scroll bars in excel. How to show hidden scroll bars in Excel","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/","og_locale":"en_US","og_type":"article","og_title":"How to disable\/Invisible Horizontal\/Vertical Scroll Bar","og_description":"All about options to Hide horizontal or vertical scroll bars in Excel. VBA to hide horizontal or vertical scroll bars in excel. How to show hidden scroll bars in Excel","og_url":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/","og_site_name":"Let&#039;s excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2011-10-11T09:51:17+00:00","article_modified_time":"2022-08-02T21:44:43+00:00","og_image":[{"width":800,"height":538,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Show-hide-Scroll-Bar-2.jpg","type":"image\/jpeg"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"How to disable\/Invisible Horizontal\/Vertical Scroll Bar","datePublished":"2011-10-11T09:51:17+00:00","dateModified":"2022-08-02T21:44:43+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/"},"wordCount":144,"commentCount":1,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Show-hide-Scroll-Bar-2.jpg","articleSection":["Excel Macro","Excel Macro Basics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/","url":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/","name":"How to disable or hide scrollbars in Excel using Excel Macros-Horizontal\/Vertical Scrollbars","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Show-hide-Scroll-Bar-2.jpg","datePublished":"2011-10-11T09:51:17+00:00","dateModified":"2022-08-02T21:44:43+00:00","description":"All about options to Hide horizontal or vertical scroll bars in Excel. VBA to hide horizontal or vertical scroll bars in excel. How to show hidden scroll bars in Excel","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Show-hide-Scroll-Bar-2.jpg","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Show-hide-Scroll-Bar-2.jpg","width":800,"height":538},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2011\/10\/how-to-disableinvisible-horizontalvertical-scroll-bar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro","item":"https:\/\/vmlogger.com\/excel\/macro\/"},{"@type":"ListItem","position":3,"name":"How to disable\/Invisible Horizontal\/Vertical Scroll Bar"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let&#039;s excel in Excel","description":"Let&#039;s share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12054"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=12054"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12054\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media\/13931"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12054"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12054"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12054"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}