passeord Protect for excel formula and VBA code

  • Thread starter Thread starter deen
  • Start date Start date
D

deen

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,
 
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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word VBA for deleting Selected Row 0
Excel Formula Required for VBA code for excel 0
Excel VBA - Problem with Closing Print Preview 0
vba macro that allows insertion of symbols at cursor 0
Excel Excel macro and passwords 3
Excel VBA Project Has Protection? 2
Changing VBA code to paste values 0
Remove Protected Macro Code from Excel Module 4

Back
Top