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.
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.
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.
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
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
Best Regards,
Carlos Paleo.
To every problem there is a solution, even if I dont know it, so this posting is provided "AS IS" with no warranties.
If Debugging is harder than writing a program and your code is as good as you can possibly make
it, then by definition you're not smart enough to debug it.
http://www.mugrs.org
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
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.
Best Regards,
Carlos Paleo.
To every problem there is a solution, even if I dont know it, so this posting is provided "AS IS" with no warranties.
If Debugging is harder than writing a program and your code is as good as you can possibly make
it, then by definition you're not smart enough to debug it.
http://www.mugrs.org
Many thanks my dear