Hide columns through vba

Hi All

I am trying to a hide entire Column B in sheet 2

User enters to values in sheet 1 in various (A1:A20) rows . where as COLUMN B in sheet 2 has some functions like addition, concatenate, if and give a values
after data is entered in sheet 1. column A (a1:a20) in sheet 2 is just a description

I dont want users have to access to column B in sheet 2.

I have created a command button where it takes only the values from COLUMN B and copies them in COLUMN C.

So the only thing i need to do this is when user enters SHEET 2 the user should see only columns A and C.

Can we hide column B through VBA Code and how to unhide the column whenever the workbook creator wants to make some changes in column B in sheet 2
Can we put in password or go and change the code so that column B is visible.

Thanx for your help in advance

Chakri.

Simpler than using VBA would be to use Worksheet protection after Locking & Hiding the cells in Column B

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.


How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save