Solved: Hiding columns

[tofimoon4]

Dear sir,with best regards,i need your help by a code to prevent showing the columns that i have hiding except entering password .
Thanking you in advance.

[Jacob Hilderbrand]

You can hide the columns you want and the protect the sheet with a password. If you are using Excel 2007 or 2010 this would be on the Review tab of the Ribbon in the Changes group.

[tofimoon4]

Dear sir,with my thanks,i am using excel 2003 and anyone can open the hiding columns by this way by putting the pointer on and pull outside,i need a codes to prevent and allow ( pulling and hiding ).
My regards

[Paleo]

Hi tofimoon4,

did you try this already?
- Select a cell within the column(s) to be hidden;
- From the Format menu, select Column » Hide;
- From the Tools menu, select Protection » Protect Workbook...;
- You will see this box
- Type a password in and Click OK

[tofimoon4]

Dear sir,with my thanks,i have tried this way before but i don't need to protect all the sheet ,i need to prevent pulling the columns i have hiding only.
Many thanks for help

[Paleo]

Hi tofimoon4,

note that when you protect a workbook you only protect cells with "Protect" property enabled. You can simply disable this property and all your cells wont be protected.

[tofimoon4]

Many thanks my dear