+ Reply to Thread
Results 1 to 5 of 5

Hide columns in multiple worksheets

  1. #1
    Forum Contributor
    Join Date
    09-25-2013
    Location
    Cape Town South Africa
    MS-Off Ver
    Excel 2013
    Posts
    103

    Hide columns in multiple worksheets

    Hi
    I have multiple worksheets in a workbook.
    I want to hide columns A,C,D,G to O in all the worksheets of this workbook.
    Any assistance to create a code that I can use to perform this task would be much appreciated.
    Last edited by Tyso; 09-29-2013 at 10:49 AM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,747

    Re: Hide columns in multiple worksheets

    Try this:
    Please Login or Register  to view this content.

  3. #3
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,598

    Re: Hide columns in multiple worksheets

    Try this, edit to suite,
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    09-25-2013
    Location
    Cape Town South Africa
    MS-Off Ver
    Excel 2013
    Posts
    103

    Re: Hide columns in multiple worksheets

    Unbelievable - reply within minutes!!!!!!!!!!!!
    Thank you so much alansidman - it works

  5. #5
    Forum Contributor
    Join Date
    09-25-2013
    Location
    Cape Town South Africa
    MS-Off Ver
    Excel 2013
    Posts
    103

    Re: Hide columns in multiple worksheets

    Thank you so much davesexcel - it works!

+ 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. Macro to hide columns and change formulas in multiple worksheets
    By Catthy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-02-2012, 10:26 PM
  2. [SOLVED] Hide empty columns that appear the same from multiple worksheets
    By tinhtu in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-22-2012, 01:16 PM
  3. Hide empty columns from multiple worksheets
    By tinhtu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2012, 02:19 PM
  4. Checkbox to hide columns across multiple worksheets
    By BrakeJake in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2012, 09:49 PM
  5. Hide columns in multiple worksheets based on one cell.
    By -Johan- in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-03-2011, 02:36 AM

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