+ Reply to Thread
Results 1 to 10 of 10

Hide columns in multiple worksheets - each sheet has its own name

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

    Hide columns in multiple worksheets - each sheet has its own name

    Hi
    I have multiple worksheets in a workbook.Each worksheet has its own name.
    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.

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Hide columns in multiple worksheets - each sheet has its own name

    Hi, Tyso,

    you had the basic answer in http://www.excelforum.com/excel-prog...orksheets.html - and please do not edit the posts when an answer has been given:
    Please Login or Register  to view this content.
    Different names for worksheet are only of interest if you want to hide on special worksheets.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

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

    Re: Hide columns in multiple worksheets - each sheet has its own name

    Hi HaHoBe
    My apology - I want to hide on special worksheets. Any assistance will be much appreciated.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Hide columns in multiple worksheets - each sheet has its own name

    Which special worksheets do you wish to hid the columns in?
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

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

    Re: Hide columns in multiple worksheets - each sheet has its own name

    No out alansidman

  6. #6
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Hide columns in multiple worksheets - each sheet has its own name

    Hi, Tyso,

    use a Select Case:
    Please Login or Register  to view this content.
    Code will work for Sheet4 and Sheet6 only, alter the names to suit.

    Ciao,
    Holger

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

    Re: Hide columns in multiple worksheets - each sheet has its own name

    Hi HaHoBe

    Thank you so much for solving my problem! Much appreciated!

  8. #8
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Hide columns in multiple worksheets - each sheet has its own name

    Hello Tyso,

    Please be polite and at least acknowledge HaHoBe's request,i.e.

    you had the basic answer in http://www.excelforum.com/excel-prog...orksheets.html - and please do not edit the posts when an answer has been given:
    This is merely a harmless reminder to empasize the importance of that request.

    Thank you for your understanding and compliance.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

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

    Re: Hide columns in multiple worksheets - each sheet has its own name

    Hi HaHoBe

    I do acknowledge your request,i.e.

    you had the basic answer in http://www.excelforum.com/excel-prog...orksheets.html - and please do not edit the posts when an answer has been given:

    Please accept my apology.

  10. #10
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Hide columns in multiple worksheets - each sheet has its own name

    Hi Tyso,

    Thank you for your positive response.

    Lekker aand vir jou!

    Regards

+ 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. [SOLVED] Hide columns in multiple worksheets
    By Tyso in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-29-2013, 10:47 AM
  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