How can I prevent others from viewing or changing my VBA code?

If you use Excel 97 or later... Activate the VB Editor and select your project in the Projects window. Then choose Tools - xxxx Properties (where xxxx corresponds to your Project name). In the Project Properties dialog box, click the Protection tab. Place a checkmark next to Lock project for viewing, and enter a password (twice). Click OK, and then save your file. When the file is closed and then re-opened, a password will be required to view or modify the code.

Microsoft Excel Training

Microsoft Excel Training We Provide
Professional Training For Microsoft Excel With Video Example

Games in Microsoft Excel

Some where I have heard about playing games in Microsoft Excel ,I have tried a lot about it but failed. Some people told me it is possible only when you have a licensed Microsoft Office, even I have licensed Microsoft Excel in my office but I have not found any game in Excel. If you know how to play games in Excel please guide.

It will be a great help.

You can visit this site for advanced Microsoft Excel Training
Free Microsoft Excel Training

Thanks a lot
Shailendra

FREQUENCY FUNCTION

I am little bit confused about Frequency function in Microsoft Excel. If any one know about this function, please let me know how and where to use this function.

ISERROR in Microsoft Excel

While performing some Mathematical calculation in excel many error comes as result as #DIV/0!
To hide these errors in the result use combination of IF, ISERROR and your calculation like this.

=IF(ISERROR(C4/D4),0,C4/D4)

ISNA and Vlookup in Microsoft Excel

I believe you are frequent user of Vlookup function. Have you ever send #N/A in the result.

When you apply Vlookup on lookup value is it is available in Table array corresponding result will be displayed and if it is not available in Table array an error #N/A will be returned that looks very funny in the result.
To avoid this we use combination of IF, ISNA function with Vlookup, Syntax is as following.

=IF(ISNA(VLOOKUP(C6,$F:$F,1,0)),"",VLOOKUP(C6,$F:$F,1,0))

This formula will replace all #N/A to blank. You can put your custom text or 0 in place of "".

C6 is lookup value
F:F is table array

Try it yourself.

Can any one guide me how to use calculated field in Pivot Table. I making a report in wihch i want to show sum of two fields that are present in data but i do not know how to display the sum.