YouTube on MSN

Create clickable tabs inside an Excel sheet

In this video, learn how to create fully clickable tabs inside a single Excel sheet that change colors when selected, ...
TechRepublic

10 ways to reference Excel workbooks and sheets using VBA

Excel offers myriad options for referring to workbooks and sheets in your VBA code. See which methods make sense in which situations. Referencing workbooks and sheets programmatically generates a lot ...