Workbook Designer Interface
Workbook Designer contains more tools than the Edit Design Data interface. However, some of the advanced features of Edit Design Data are not available when working through Workbook Designer. The automatic formatting of turning cells that contain formulas to red text is not available, nor is the ability to quickly add defined names as it was with Edit Design Data.
New – Allows you to add a new workbook.
Open – Allows you to open a workbook saved to the disk.
Save – Allows you to save the changes made to the workbook.
Print – Allows you to print the current tab of the open workbook.
Print Preview – Allows you to preview the current tab before printing.
Set Microvellum Title – Allows you to set the name of the workbook to the Microvellum title (G, W, L, S, etc.)
Undo – Allows you to undo changes.
Redo – Allows you to redo changes that were undone.
Cut – Allows you to cut a cell, or range of cells, from the worksheet.
Copy – Allows you to copy a cell, or range of cells, from the worksheet.
Paste – Allows you to paste a cut or copied cell, or range of cells, to another location.
Find – Allows you to find a text string within the worksheet, workbook, or workbooks.
Replace – Allows you to find a text string and replace it with something different within the worksheet, workbook, or workbooks.
Show Workbook Explorer – Allows you to access Workbook Explorer, which can be used to perform additional formatting, adding additional worksheets, and accessing the page setup.
Name Manager – Allows you to access the Name Manager, which displays all the defined names and ranges within the current workbook. This tool can be used to add, edit, or delete defined names. It can also be used to find overlapping defined names.
Show Watch Window – Allows you to add cells from other worksheets or workbooks, so they can be monitored when making changes to other variables that would affect the cells being watched.
Insert Function – Allows you to access the Formula Editor.
Add Comment – Allows you to add a comment to a cell.