passeord Protect for excel formula and VBA code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

deen - 03 Dec 2007 06:31 GMT

Hi,

i have excel sheet its contain lot of formula and VBA(macro) code,

its for used for user purpose,

i need how to protect the formula and VBA at the time of user using.

kindly let me know , kindly help me out

i need user password : for user can upload the data in non restriction
cell,

admin password : can change any thing(change power)

pls help me,

Reply to this Message

scubadiver - 03 Dec 2007 09:34 GMT

Please ask on the Excel board.

> Hi,
>
[quoted text clipped - 12 lines]
>
> pls help me,

Reply to this Message

deen - 04 Dec 2007 08:54 GMT

HI,

thx for the reply,

=IF(AND($B3<21),"NOT ELGIBLE - AGE IS <21",IF(AND(VIEW!$D$7=0),"
",IF($B3>60,"NOT ELGIBLE - AGE IS >60","ELGIBLE - AGE IS >=21 TO
<=60")))

This kind formula i was used in sheet2,

i need know this same formula to be using with macro coding,

Result to be appear in sheet1 ( A2) cell,

kindly help me,

On Dec 3, 2:34 pm, scubadiver <scubadi...@discussions.microsoft.com>
wrote:

> Please ask on the Excel board.
>
[quoted text clipped - 14 lines]
>
> > pls help me,

Reply to this Message