Microsoft Excel Question:
Download Questions PDF

Is there a way to protect the macros I create so people can not see or alter them?

Go to Tools > VBAProject properties, lock the project for viewing, and enter a password.

Download MS Excel Interview Questions And Answers PDF

Previous Question	Next Question
Is it possible to call a macro from the condition true or false side of a worksheet formula? i.e. If(A2="OK",Run macro1,run macro2)?	I want to show a userform each time my file is opened?