Making worksheets very hidden in Excel reduces the chances of other people accessing them. To make a sheet very hidden, set its visibility to "xlsSheetVeryHidden" in the VBA window.

Nearly every Microsoft Excel workbook I own—especially those I share with others—contains a hidden backend worksheet. It's essentially the engine room of my workbook and helps me keep my ...

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

Doing this tells Excel to add the June and July cell values to create a total. When people view the Total worksheet, they will see total sales for June and July in the worksheet's B1 cell.