Viewers INDEX


MacroSoftly Member " MEP " - Macro Entry Person.
Viewers: These utilities will be Dialog Viewers. Dialogs that show information about one thing or another. XdataDialog: This Dialog shows information about all your drives. Drive Letter, Drive Type, Volume Name, Ready?, Free Space, Serial Number. XdataDialog.xls Cell_Viewer: Use the Arrow buttons to move the position of the Activecell. The Textboxes show the current Activecell Value and Formula. If the Arrow button turns into an "X" then you have reached the edge of the worksheet. Click an Arrow button to move away from the edge and the "X" button turns back into an Arrow button. If a cell is too far to "Arrow" over to then Click the Target Cell and use an Arrow Button to continue. Cell_Viewer.xls Window_Watcher: This utility works in a similar way to the Excel Built-In toolbar "Add Watcher" Utility. Window_Watcher_Pro has bonus features: add Watch to any number of opened workbooks and any number of worksheets; the Update button updates all references to the Watch List (if a Range Name has been added or deleted, it will not be Updated); open or close workbooks, add or remove worksheets, while the form is running; an extra feature allows the user to change workbooks or sheets - Workbook / Sheet Changer (this is very useful if you have more than two workbooks opened and/or more than ten sheets in any workbook); a Watch List Column adjustor; remove single or multiple items from the Watch List; if the cell value is the same as the cell formula then will show as the value (this will avoid duplication of the same thing); there is a separate window that shows each Workbook Path Address for each entry; click "Hide Me" to hide the main form. A small "UnHide Me" form appears in the top-left corner of the screen. The Watch List shows: Workbook Name, Sheet Name, Range Name, Cell Address, Cell Value, Cell Formula. The "Update" will not show the Range Name if it is added after the Form loads. Window_Watcher_Pro.xls Window_Watcher_Pro_II.xls has an added feature. The user can save a Watch list or load a saved Watch List. Save List will save the Watch List in the same folder as the Utility. The default extension is ".mep" and will be listed in the Saved List listbox. The user can also delete any saved Watch Lists. Window_Watcher_Pro_II.xls

MacroSoftly Member " MEP " - Macro Entry Person.

Viewers:
These utilities will be Dialog Viewers. Dialogs that show information about one thing or another.

XdataDialog:
This Dialog shows information about all your drives.
Drive Letter, Drive Type, Volume Name, Ready?, Free Space, Serial Number.
XdataDialog.xls
Cell_Viewer:
Use the Arrow buttons to move the position of the Activecell. The Textboxes show the current Activecell Value and Formula. If the Arrow button turns into an "X" then you have reached the edge of the worksheet. Click an Arrow button to move away from the edge and the "X" button turns back into an Arrow button. If a cell is too far to "Arrow" over to then Click the Target Cell and use an Arrow Button to continue.
Cell_Viewer.xls
Window_Watcher:
This utility works in a similar way to the Excel Built-In toolbar "Add Watcher" Utility. Window_Watcher_Pro has bonus features:

add Watch to any number of opened workbooks and any number of worksheets;
the Update button updates all references to the Watch List (if a Range Name has been added or deleted, it will not be Updated);
open or close workbooks, add or remove worksheets, while the form is running;
an extra feature allows the user to change workbooks or sheets - Workbook / Sheet Changer (this is very useful if you have more than two workbooks opened and/or more than ten sheets in any workbook);
a Watch List Column adjustor;
remove single or multiple items from the Watch List;
if the cell value is the same as the cell formula then will show as the value (this will avoid duplication of the same thing);
there is a separate window that shows each Workbook Path Address for each entry;
click "Hide Me" to hide the main form. A small "UnHide Me" form appears in the top-left corner of the screen.
The Watch List shows:

Workbook Name, Sheet Name, Range Name, Cell Address, Cell Value, Cell Formula. The "Update" will not show the Range Name if it is added after the Form loads.
Window_Watcher_Pro.xls
Window_Watcher_Pro_II.xls has an added feature. The user can save a Watch list or load a saved Watch List. Save List will save the Watch List in the same folder as the Utility. The default extension is ".mep" and will be listed in the Saved List listbox. The user can also delete any saved Watch Lists.
Window_Watcher_Pro_II.xls