All articles with 'worksheet' Tag

Worksheet Properties via a Menu

Published on Jan 25, 2011 in Excel Howtos, hacks, Huis, Posts by Hui
Worksheet Properties via a Menu

The Properties button on the Developer Tab in Excel 2007/10 can be used to access a number of Worksheet properties normally only available through VBA and even a few which aren’t available through VBA.
Lets take them for a spin.

Continue »

How to Hide Worksheet Tabs in Excel Workbook

Published on Jan 22, 2009 in Excel Howtos, Learn Excel
How to Hide Worksheet Tabs in Excel Workbook

Excel trick to prevent users from un-hiding “hidden sheets” in an excel file.

Continue »