Features
Features include a borderless Full Screen transition for all Workbooks with the ability to toggle Headings, Gridlines, Worksheet Tabs and Scroll Bars. Kiosk works alongside the Excel Application.DisplayFullScreen allowing all the available Shortcut menu features. It also includes a Window/Worksheet Browser to quickly select Workbooks, Sheets, Charts and Images whilst running in Full Screen mode. See the Kiosk Menu feature below for more information. Kiosk has been tested on Windows XP, XP Professional, Vista & Windows 7. Please download and test using the Kiosk 3.1 Trial Version prior to Purchasing.
Kiosk is an Excel Add-In which is installed or uninstalled easily and can be setup to allow multiple users per Code License. It does not use Sub-classing or install/register any third-party DLL's and is therefore perfect for Workplace or Network scenarios where Admin rights are normally required for Software installations. See the Installing & Uninstalling Kiosk Add-In feature below for more information.
Launching Kiosk is straightforward. The Kiosk Add-In for Excel 2007/2010 is added to the Ribbon on the View Tab next to Workbook Views. The free Excel 2000+ version adds Kiosk to the View Menu.
To License Kiosk see the Licensing Kiosk feature below. To call Kiosk from VBA code see the Calling Kiosk from VBA Code feature below.
The Kiosk Add-In Menu - press F4 to view
Kiosk is installed as an Add-In via the Developer Tab for Excel 2007/2010 and is added to the Ribbon on the View Tab next to Workbook Views. Its Caption reads Transition. Pressing this button will launch the Kiosk mode. If a Workbook is present, Kiosk will launch it FullScreen. If no Workbook is present Kiosk will launch as a blank Interface - you can use the right click to Add or Open a Document. Pressing Ctrl+N will add a new Workbook, Ctrl+O will bring up the Open Dialog box (new Workbooks can also be added via the Kiosk Menu - see below).
For Excel 2000+ Kiosk is added to the File Menu under View. After you have Installed and launched the Kiosk Add-In, pressing F4 will bring up the Kiosk Menu. Pressing Esc or selecting Close FullScreen from any of the right-click shortcut Menus will exit Kiosk mode in Excel 2007/2010. In Excel 2000+ press F6 to exit Kiosk mode.
Menu Features:
The Window Browser allows you to switch between Workbooks and select the one of your choice - press the drop-down arrow in the ComboBox to view all of the Workbooks currently open.
Using the Browser arrows you can iterate through a Workbook backwards (left arrow) or forwards (right arrow) selecting Sheets, Charts, Dialogs and Macro Sheets. The currently selected Sheet Name (i.e. Sheet1) will change and be displayed as you iterate through the WorkSheets. The Browser does not select Hidden or Very Hidden WorkSheets - it steps over them. As you browse a Workbook, the default options of the Worksheet and Window will populate the various checkbox/option button items accordingly. Checking or unchecking any of the checkboxes will toggle an item.
The seven option buttons on the right-hand side allow you to set a Window to FullScreen, Restore to Normal, Minimize or in the case of multiple Workbooks, arrange a Tiled, Cascade, Horizontal or Vertical Window View. If multiple Workbooks are open, Minimizing a Window will focus the next Workbook and toggle the settings accordingly. You can also use Ctrl+F9 and Ctrl+F10 to toggle between FullScreen, Normal and Minimized Window Views when the Kiosk Menu is not displayed. Pressing the New Window Button creats a new blank Workbook, activates it and displays the settings available to toggle.
For a true Kiosk Mode (entirely borderless) you need to deselect all the checkbox items and have the FullScreen option button selected.
Go To Top · back to homepage
Installing the Kiosk Add-In
Kiosk.XLAM or Kiosk.XLA should be installed and Licensed as a regular Excel Add-In so that it is available every time Excel starts.
Note: Excel will load the Add-In from wherever you extract it to from the ZIP Archive. Microsoft Excel has default central Add-In Paths i.e. \Microsoft\AddIns which will open when you browse for an Add-In however you can choose a local or Network Drive Path to store Kiosk. If you simply double-click the Kiosk.XLAM or Kiosk.XLA file it will open and you can go through the Licensing but it will NOT be installed as an Add-In.
Install Kiosk.XLAM (Excel 2007/2010)
Please note that in order for Kiosk to work correctly you need to allow Enable Macros and perform the following:
Pre-Install for Excel 2007/2010 firstly on the Developer Tab (if this is not visible right-click on the Ribbon and select Customise the Ribbon from the Popup Menu. Under the Main Tabs section check the Developer option. Close the Menu.) click Macro Security. Then select the Macro Settings option and underneath Developer Macro Settings tick the Trust Access to the VBA Object Model checkbox.
To install for Excel 2007, Kiosk.XLAM you need to click on the Microsoft Office Button and then click Excel Options. Click the Add-Ins Category. In the Manage box, click Excel Add-Ins and then click Go. Click Browse and locate the Kiosk.XLAM Add-In. Click Ok to close the Add-Ins dialog box. An Installation Message should now appear. Kiosk will now appear in the Add-Ins list with a check next to it and a description in the box below.
To install for Excel 2010, Kiosk.XLAM open Excel and click on the Developer Tab. If the Developer Tab is not visible, right-click the Ribbon and select Customise the Ribbon from the Popup Menu. Under the Main Tabs section check the Developer option. Close the Menu. The Developer Tab should now be visible on the Ribbon. Select it and press the Add-Ins Button. Click Browse and locate the Kiosk.XLAM Add-In. Click Ok to close the Add-Ins dialog box. An Installation Message should now appear. Kiosk will now appear in the Add-Ins list with a check next to it and a description in the box below.
Install Kiosk.XLA (Free Version for Excel 2000+)
To do this for Kiosk.XLA open Excel and click on the Tools Menu. Select Add-Ins. Click Browse and locate the Kiosk.XLA Add-In. An Installation Message should now appear. Kiosk will now appear in the Add-Ins list with a check next to it and a description in the box below.
Uninstalling the Kiosk Add-In
To uninstall Kiosk simply uncheck the Kiosk box displayed in the Add-Ins list as detailed in the installation process. A message will appear informing you that Kiosk has now been uninstalled. If you no longer require the Software then delete the Kiosk.XLAM or Kiosk.XLA Add-In from your computer.
Go To Top · back to homepage
Licensing Kiosk
When you have installed the Kiosk Add-In you should see the License box as per below:
Enter your Kiosk License code (this will be sent by email following purchasing) and click the Unlock Kiosk button. If the License Code is accepted you will be able to launch Kiosk from the View Tab and you can begin using the Software. If it is incorrect you will be given the chance to enter it again. If you press the small cross to close the License box, before entering a License Code Kiosk will shutdown without licensing. When you next open Excel Kiosk will begin the licensing process over again. When you Uninstall Kiosk any attempt to re-install the Software will require the License Code to be re-entered.
Note: In the Trial versions after the limited launch total is reached, Kiosk will automatically enter the licensing phase - you should then purchase the Software to get a valid Kiosk License Code..
Go To Top · back to homepage
Calling Kiosk from VBA Code
Calling the Kiosk Add-In Function:
Once Kiosk is installed you can call the Kiosk Add-In function called Kiosk. Ensure that the Kiosk Add-In is correctly installed and that you are not running Kiosk in Full Screen mode and then press alt+F11 to open the VBA IDE. Enter the code below in a Subroutine. Run the code to launch Kiosk. The function does not take or return a value. Press Esc to Exit Kiosk mode as usual or use SendKeys to pass Esc as a virtual KeyPress.
Application.Run "Kiosk.xlam!a_main.Kiosk"
Go To Top · back to homepage
