VBA and VB.Net Tutorials, Education and Programming Services
Worksheets
Unprotecting and Protecting: Explains how to protect and unprotect sheets using VBA. Useful when you want your sheets to remain protected from the end-user but remain unprotected from the program.
Searching: Explains the basic algorithm to search for a value.
Working With Sheets: Explains the different ways of referencing a worksheet, the difference between a worksheets name, index and variable name. Also explains how to create and copy a worksheet.