Category Archives: Protection

A Complete Guide to Loops in VBA

When you write good VBA code, you try not to repeat yourself too often – in other words, you try not to write the same code for repetitive tasks more than once.  Looping structures are an invaluable part of VBA and you will use them

No Thumbnail

VBA Excel Working With Protected Sheets

Jump To: Unprotecting and Protecting the Worksheets Unprotecting and Protecting Workbooks Unprotecting and Protecting the Worksheets: As a VBA programmer you will often have protected sheets where you would like your program to be able to modify but still remain protected from the users. There