~*Excel Problem*~

[usman ali]

Asslam-o-Alaikum
excel 2007 main formula ko lock kesy lagatay hain? jiss ko mery siwa koi na delete kar saky?

[smartyounus]

Janab bohat ASAN hia....

yeh FILE attched kia hia DOWNLOAD kar k DEKHAIN PIC hian thxz

ڈاؤن لوڈ کریں

[smartyounus]

اگر جناب پھر بھی کوئ پرابلم ہو تو میں حاضر ہوں

[syar]

Aik tareeqa tu aap ko smartyounus ne bataya he. Dosra tareeqa ye ha

Jis cell m aap ne formula lekha ho us cell ko select karain.

Data k tab m ja kar cell validation ko select karain.
Setting k tab m allow k dropdown menu se custom select karain.
Formula ka box m =FALSE lekhain aap ka masla hal ho jae ga. Sirf wohe cell lock ho ga jis me formula ha ya jis range ko apne select keya ho.

Pori sheet ko protect karna theek ha Leekan is m aik problem aae ge ka sheet protect karne k bad user ya aap jab tak sheet ko unprotect nahee karain ge tu aap workbook k full features se faida nahee utha sakain ge.

Jis se bachne k leye aap VBA (MACRO) k code istimal kar sakte hain. Jo k sheet m mojood sirf un cells he ko protect aur formula ko hide kar de ge jin m formula ho. Baqi sare feature kam karain ge. Formula wale cell ke value nazar aae ge leekan formula nazar nahee aae ga.
Agar zaroorat ho tu reply. Waise oper smart younus k method aap ka masla hal kar de ga.

regards

[raz24726]

@ syar
agreeed

[usman ali]

Agr excel ki tamam sheets ko ak sath lock karna ho to kasay karen gaye???

[Haseeb Alamgir]

password laga lo

[M mansoor nazir]

Password is a good Trick

[janibaba]

bhia jan agr ye kam office-2003 me kia jay to kese, mtlb formule wale cell ko lock krna ho to plzzzzzzzzz

[Ganxtr]

shukriya!
Mein b is k mutaliq janana chahta tha.

[usman ali]

Thanks 2 All

[afzaldir]

Good...