Tag Archives: Worksheets

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

No Thumbnail

Excel VBA, Working With Sheets

In this article I will explain how to work with the worksheet object. One the most important thing to know when working with worksheets is understanding the difference between the items below: Sheet Object’s Variable Name Sheet Name Sheet Index I will also explain how