| | | None of the worksheets within an add-in are visible when the add-in is loaded. Although they can be used for reference within the VBA code. | |
| | | When changes are made to an add-in you will not be prompted to save your changes when Excel closes. | |
| | | Any public macros in your code modules will not appear automatically in the (Tools > Macro > Macros) dialog box. They can however be typed in manually and run. | |
| | | Any function can be referenced (i.e. as a worksheet function) without the need to prefix the workbook name. | |
| | | Any VBA code added to an add-in will be visible unless a password is added to the VBE project. | |
| | | It is not possible to bypass the automatic Workbook_Open() event by holding down the Shift key. | |
| | | The IsAddin workbook property that can be visible when you select the ThisWorkbook object in the VBE is set to True. | |
| | | A workbook must have at least one visible worksheet. It is not possible to delete or hide all the worksheets in a workbook. | |
| | | When changes are made to a workbook you are always prompted to save your changes when the workbook is closed. | |
| | | Any public macros in your code modules will appear in the (Tools > Macro > Macros) dialog box. | |
| | | Any function can be referenced (i.e. as a worksheet function), although when using the function in another workbook it must be prefixed by the name of the workbook (e.g. WbkName!MyFunction()). | |
| | | Any VBA code added to an add-in will be visible unless a password is added to the VBE project. | |
| | | It is possible to bypass the automatic Workbook_Open() event by holding down the Shift key. | |
| | | The IsAddin workbook property that can be visible when you select the ThisWorkbook object in the VBE is set to False. | |
