help for ....

leduc alain · 04-06-2007, 04:28 AM

i am looking if i can protect colom. on exel, that does not give any acces to anypersonn modified the contents. of it., and at the same time they could work on other colums. on the same sheet.
2) their are any way to hide a full sheet that has some formulas to be links on a work sheet. please help...step by step please if their are any way.

**Glaswegian** · 04-06-2007, 06:06 AM

Hi

Yes we can do all that. Some questions first...

What version of Excel are you using?
You want to hide a complete worksheet or just the formulas? Is it to be completely hidden so that no user will be able to access it?

leduc alain · 04-06-2007, 07:31 AM

yes sir , i am using office 2003 excel 203 then . i wanna hid a fornula that no boddy can acces to get it. or to steel it. thank you for helping.

**Glaswegian** · 04-06-2007, 11:25 AM

Hi again

You can hide a formula and stop it showing in the formula bar by first selecting the cell or cells you want. Then go to Format > Cells > Protection tab and check the 'Hidden' box. You will now have to protect the worksheet for this to be effective. Go to Tools > Protection > Protect Sheet. You will now see various options about the level of protection that suits you best. Once you've chosen the options you need, create a password and that's you finished.

04-06-2007, 04:28 AM	#1 (permalink)
leduc alain Registered User Join Date: Jul 2006 Posts: 115 OS: xp	help for .... i am looking if i can protect colom. on exel, that does not give any acces to anypersonn modified the contents. of it., and at the same time they could work on other colums. on the same sheet. 2) their are any way to hide a full sheet that has some formulas to be links on a work sheet. please help...step by step please if their are any way. __________________ He teaches ill..........who teaches all????

04-06-2007, 06:06 AM	#2 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 25,482 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Re: help for .... Hi Yes we can do all that. Some questions first... What version of Excel are you using? You want to hide a complete worksheet or just the formulas? Is it to be completely hidden so that no user will be able to access it? __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner

04-06-2007, 07:31 AM	#3 (permalink)
leduc alain Registered User Join Date: Jul 2006 Posts: 115 OS: xp	Re: help for .... yes sir , i am using office 2003 excel 203 then . i wanna hid a fornula that no boddy can acces to get it. or to steel it. thank you for helping. __________________ He teaches ill..........who teaches all????

04-06-2007, 11:25 AM	#4 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 25,482 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Re: help for .... Hi again You can hide a formula and stop it showing in the formula bar by first selecting the cell or cells you want. Then go to Format > Cells > Protection tab and check the 'Hidden' box. You will now have to protect the worksheet for this to be effective. Go to Tools > Protection > Protect Sheet. You will now see various options about the level of protection that suits you best. Once you've chosen the options you need, create a password and that's you finished. __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner