Excel Icon

Valid XHTML 1.0!

Valid CSS!


zTools

A small collection of tools to help Excel users in their daily work

Visibility

A modal Userform that lists the sheets of the workbook allowing you to set their visible property, useful when developing big workbooks with lots of sheets.

.

Additional Visibility features are included in the Sheet tab shortcut menus

Print Manager

This modal UserForm allows you to pick and choose the sheets you want to print. It's modal so you can use built in functionality to play with the settings of each sheet.

.

zCellWatch

zCellWatch functionality added for ease of addin management

.

Stamp

Time stamp facility - inserts a string of today's date/time which you can format and forget

.

.

zRestrict

zRestrict hides columns and/or rows below and to the right of the selected cell, optionally to all sheets. This is still experimental, let me know of any bugs

.

The menus in zTools are generated using code from John Walkenbach's tip number 53, really takes the headache out of menus

The buttons in Visibility are handled using code based on John's tip number 44 "Handle Multiple UserForm Buttons With One Subroutine"

Blimey, that's a great website


.

.