Difference between revisions of "Menu"

9 bytes removed ,  16:44, 23 October 2013
no edit summary
Line 13: Line 13:
# Once the [[Report Pack]] is opened, click on the name of the report to display;
# Once the [[Report Pack]] is opened, click on the name of the report to display;
# The report will refresh to display data
# The report will refresh to display data
== How does the Menu work ==
When BudgetLink starts the Menu.xls Workbook opens and activates the Worksheet call Menu. The Menu Worksheet has a Menu Table. The Menu Table displays a list of Workbooks saved in the saved in the [[BudgetLink System Folder]]. Each Workbook in the System Folder is a Report Pack or Input Pack. Upon clicking a Menu item, the selected Workbook opens and activates the Menu Worksheet in that Workbook. The Menu Table in that Menu Worksheet displays a list of Worksheets in that Workbook as a sub menu under the Report Pack. Upon clicking a Sub Menu item the selected Worksheet is activated. The Worksheet can also be selected by clicking on the Worksheet tabs in Excel


== How to automatically hide reports as you navigate through the Menu ==
== How to automatically hide reports as you navigate through the Menu ==
Line 28: Line 24:
== How to leave reports open as you navigate through the Menu ==
== How to leave reports open as you navigate through the Menu ==


By default, as you navigate through the reports and workbooks, Excel will open them as new workbooks and display them in the Windows Taskbar. You can change this behaviour so that only the current report is displayed and all other reports get closed. To do so, see [[How to automatically close reports as you navigate through the Menu]].
By default, as you navigate through the reports and workbooks, Excel will open them as new workbooks and display them in the Windows Taskbar. You can change this behaviour so that only the current report is displayed and all other reports get closed. To do so, see [[How to leave reports open as you navigate through the Menu]].
 
== How does the Menu work ==
 
When BudgetLink starts the Menu.xls Workbook opens and activates the Worksheet call Menu. The Menu Worksheet has a Menu Table. The Menu Table displays a list of Workbooks saved in the saved in the [[BudgetLink System Folder]]. Each Workbook in the System Folder is a Report Pack or Input Pack. Upon clicking a Menu item, the selected Workbook opens and activates the Menu Worksheet in that Workbook. The Menu Table in that Menu Worksheet displays a list of Worksheets in that Workbook as a sub menu under the Report Pack. Upon clicking a Sub Menu item the selected Worksheet is activated. The Worksheet can also be selected by clicking on the Worksheet tabs in Excel


== Notes ==
== Notes ==
2,725

edits