This video introduces you to how to write code to work with sheets in VBA and shows you a few tricks with renaming, selecting and hiding sheets.
Make sure you stay on the video until about 3.30 mins in as the video introduces you to the veryhidden property of a sheet. I use this property a lot as it stops people unhiding them in the Excel interface.
The video finishes by showing you how to select sheets with VBA.
I hope you enjoy this video on Working with sheets in VBA – if you have found it useful or have any questions please use the comments box at the base of this page.