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.
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.
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:
Different names for worksheet are only of interest if you want to hide on special worksheets.Please Login or Register to view this content.
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
Hi HaHoBe
My apology - I want to hide on special worksheets. Any assistance will be much appreciated.
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
No out alansidman
Hi, Tyso,
use a Select Case:
Code will work for Sheet4 and Sheet6 only, alter the names to suit.Please Login or Register to view this content.
Ciao,
Holger
Hi HaHoBe
Thank you so much for solving my problem! Much appreciated!
Hello Tyso,
Please be polite and at least acknowledge HaHoBe's request,i.e.
This is merely a harmless reminder to empasize the importance of that request.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:
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] .
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.
Hi Tyso,
Thank you for your positive response.
Lekker aand vir jou!
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks