excel to VBA

[prakashyadav]

Hi,
I am attaching one excel.
Workbook has 2 sheets.Main and database
if i fill b4,d4 & e4 i got data in c4 and f4.

can i write VBA for this.

Actually i want to hide my database or lock, so that nobody knows my database.

Thanks & regards,

Prakash Kumar.

 

[Deepak]

What u actually wish to do in this. Do you want auto value in C,D,E,F base on A & a drop down in A based on Site ID on database sheet?

 

[SirJB7]

Hi, prakashyadav!

As a new user you might want to (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, if I were you I'd check this:
http://chandoo.org/forum/threads/wh...t-method-to-secure-workbook.11962/#post-70156
and then I'd run away thru the wall like in the cartoons.

Regards!