PRIME Resources
Software Products

Contact PRIME

Contact Webmaster

PRIME 95 for Excel 95 Utility Descriptions

PRIME 95 for Excel is the latest collection of utilities for Microsoft Excel 95 from PRIME Consulting Group. From the authors of The Underground Guide to Excel (Addison Wesley) you'll find these utilities increase your productivity working with Excel. In addition to the utilities you will have access to 40+ custom VBA procedures in PRIME 95's API. These subroutines and functions can be called directly from your own VBA macros.

• Cell Protection Viewer -- PRIME Cell Protection Viewer provides an at-a-glance visual display of all unlocked or locked (or both) cells in the current worksheet. The utility can examine either the current selection or the used area. You can also set your own preference settings for the desired outcome of both cell protection states.

• Name Assistant -- PRIME Name Assistant provides a list of all names in the current workbook, including hidden names, and displays statistics for those names. Name Assistant also allows you to go to a range name's location, paste a list of all names and their statistics into a worksheet, toggle names between visible and hidden, and delete names.

• Toolbar Assistant -- PRIME Toolbar Assistant provides a complete list of all active toolbars by name (this includes all hidden and visible toolbars), along with their button contents. Button contents include slot numbers, ToolTip text, the fully qualified macro assignment, whether the button face is built-in or custom, and the button id number. Toolbar Assistant allows you to add or change the ToolTip text and the macro assignment for any button on the fly. You can catalog this comprehensive list into a table on a worksheet.

• TUGExcel Tools -- Various micro-macros built in The Underground Guide to Excel (Addison-Wesley). Complete with ready to load custom toolbars with full functionality!

• Window Assistant -- PRIME Window Assistant allows you to select for closing one, several, or all visible Excel windows. You can also create a new window, split a window, arrange windows, and activate a specific window then quit.

• Zoomer -- Zoomer makes it easy to control your worksheet's zoom setting. You can control the zoom setting with a slider (like the controls on a stereo) or select it from customized lists of recent and fixed settings.

• PRIME 95 Application Programming Interface -- You can call PRIME 95 subroutines and functions from within your own VBA code. 40+ in total. See help topic You Can Call PRIME 95 Custom VBA Functions and Subroutines.