Geek Documentation Logo

Kiosk

Version 9.1

  1. About Kiosk
  2. Getting Started
  3. The AddIn
  4. Enabling Auto Launch Kiosk Mode
  5. Screen Shots
  6. Videos
  7. FAQ
  8. BUGS
  9. Support
  10. Version History (Changelog)

Introduction

  • Purchase : Kiosk
  • Software Name : Kiosk Full Screen AddIn for Excel · 2013, 2016 (32bit or 64bit) & 2019 (64bit) running Windows 10 or 11
  • Software Version : v9.1 Read more about Kiosk v10
  • Website : airportal.sellfy.store/

If you have already purchased this Software, let me take a moment to thank you for being a loyal customer
You are entitled to free lifetime updates for ALL future builds INCLUDING the latest newer version v10 available here: Kiosk v10 (please email me if you have purchased Version 9 and I will send you it F.O.C or of course you could just purchase the newer version and help towards future development of this Software!)

This documentation is to help you understand the Software and to give you a more meaningful insight into what it can do. Please go through the documentation and read it carefully · Moderate VBA skills will be required

Requirements

You will need the following Excel Version & Prerequisite to use this Software

  1. Excel 2010, 2013 & 2016 (32bit or 64bit), Windows 11
  2. Basic Excel skills to add the File as an AddIn
  3. Access to the VBOM (a setting in Excel) & Macro's must be enabled
  4. Windows PC · NOT a Mac!

No support is provided for customization or development of this Software





About Kiosk #back to top

Kiosk Full Screen Excel AddIn for Excel 2013+ working with Windows 10 and 11. Go Kiosk mode as Full Screen Excel with a Border, Full Screen Excel without a Border or a Manual Window size with or without a Border. Hide any other common Excel objects like the Ribbon, Worksheet Tabs, Statusbar, Gridlines, Formula Bar etc. All of the settings before launching are embedded into Excel and added back after pressing {F4}. You can setup the Kiosk AddIn (once installed as an AddIn) to launch automatically when opening an Excel File. You can also Save the current Kiosk configuration so that it is available each time you use Excel with your settings. This is Version 9.1

I like to use Kiosk to give me FullScreen Excel (Maximum Window space) and then still allow the Formula Bar and Sheet Tabs to let me switch Sheets. This can be handy when presenting Excel via a Projector when you want to have as much actual usable area to display as possible or just to present a Sheet in a Kiosk Style, no Border, nothing - check out the Videos for examples of usage with Excel to get an idea of what Kiosk can do

Please note: both the .XLSM and the .XLAM files are included. You can use this Software directly from the .XLSM File or as it is intended by Installing the Software as an AddIn

Kiosk Fullscreen Excel Image

Getting Started #back to top

The download File - Kiosk_v9_AddIn.zip

Right-click and extract the Zip Archive to your PC. Two Files will be extracted, Kiosk_v9_AddIn.xlsm and Kiosk_v9_AddIn.xlam

The download File - Kiosk_v9_AddIn.xlam

Install the 'Kiosk_v9_AddIn.xlam' File. Copy Kiosk_v9_AddIn.xlam. Open Excel. File->Options. Click on Add-ins. Click 'Go...'. Click 'Browse'. Right-click and Paste the AddIn. Select the File and click OK. Click OK again. The AddIn is now installed and ready for use

Quick Steps

1. Open a Workbook of your choice. On the View Tab of the Ribbon select a Full Screen Mode and press the Kiosk Icon to launch the WIndow - remember to press {F4} Key to return all of the settings back to normal

The download File - Kiosk_v9_AddIn.xlsm

Open the 'Kiosk_v9_AddIn.xlsm' File. Sheet1 contains the Kiosk Icon and internally will store the Radiobutton PNG images. The Settings Sheet will internally store all of the settings each time a Kiosk WIndow is launched

Quick Steps

1. On the View Tab of the Ribbon select a Full Screen Mode and press the Kiosk Icon to launch the Window - remember to press {F4} Key to return all of the settings back to normal - Kiosk is best ran as an AddIn

The AddIn #back to top

The Kiosk AddIn is added to the View Tab of the Ribbon after the 'Workbook Views' Group

Here are all of the AddIn Settings:

Kiosk Settings

The first Group contains the Kiosk Button which launches whatever Mode is selected - press this after you have selected any of the other settings remembering that {F4} will exit Kiosk Mode. The next Group are the Radiobuttons used to select a single Mode in which to go Full Screen or Manual size. The choices are Border, Borderless, Manual Border or Manual Borderless. The first two options will both go Full Screen, whereas the second two will render a Window for Excel based upon the settings for the Kiosk Metrics. The third Group, the 'Full Screen Hide' Group, contains checkboxes that can be set to Hide any or all of the Excel Objects like Headings or the Formula Bar. This Group also includes the ability to Automatically Launch into Kisk Mode whenever an Excel File is opened and you have the AddIn installed. The fourth Group, the 'Kiosk Metrics' are used to change the Top, Left, Width and Height of a Kiosk Excel Window on the fly. In version 9.1 I have also added another Button, a Kiosk Save Button that allows you to Save all of the Kiosk settings in the AddIn

Enabling Auto Launch Kiosk Mode #back to top

You can Enable Auto Launch Kiosk Mode to allow any Excel Workbook to automatically go straight into Kiosk Mode

Follow these steps:


#1. Install Kiosk as an AddIn
#2. Open Excel
#3. Click on View and configure how you want to launch Kiosk but do not launch it
#4. In the Full Screen Hide And Auto Launch Group on the Ribbon click Auto Launch to check it
#5. Now Click Save in the Kiosk Save Group on the Ribbon
#6. Close Excel
#7. Open any file to launch into Kios Mode every time

Screen Shots #back to top

Excel Kiosk Manual Window 640px by 400px at Top position zero and Left position zero, with a Border and only the Formula Bar and the Status Bar rendered

Kiosk Manual Excel Border Window Screen Shot

Excel Kiosk Manual Window 640px by 400px at Top position zero and Left position zero, without a Border and only the Formula Bar and the Status Bar rendered. Please Note: the Border you see is my Desktop Window below when Excel is still selected. If you click out of the Window Excel has no visible Border

Kiosk Manual Excel Borderless Window Screen Shot

Excel Kiosk Window Full Screen with a Border and showing a visible Formula Bar and Status Bar

Kiosk Full Screen with a Border Window Screen Shot

Excel Kiosk Window Full Screen without a Border and showing a visible Horizontal Scrollbar, Formula Bar and Status Bar

Kiosk Full Screen without a Border Window Screen Shot

Videos #back to top

Installing the Kiosk AddIn and going Full Screen

Here is a quick video demonstrating how easy it is to install the Kiosk AddIn and then launch Full Screen. I also create a smaller Bordered WIndow on the Screen, hiding all of the Excel Objects except the Cursor

Here is a video demonstrating Kiosk Full Screen AddIn with my Holiday Planner Software

FAQ #back to top

There are currently no frequently asked questions about this Software that cannot be answered via this documentation

BUGS #back to top

BUG #1. There is an issue with the Manual Borderless Option in Windows 11 using Dark Mode where the Window does not redraw when exiting - ths is currently an open issue and I am looking into a workaround, 29/06/2022

Support #back to top

Please remember you have purchased very affordable Software and you have not paid for a full-time Software design agency - I am but one man. Occasionally I may help with small tweaks, but these requests will be put on a much lower priority due to their nature. You have not PAID for Support, Support is 100% optional and I provide it for your convenience, so please be patient, polite and respectful

Support (limited) for my Software includes:

* Responding to questions or problems regarding the Software and its features
* Fixing valid (replicated) bugs and reported issues for the VERSION I HAVE WRITTEN

Software support does not include:

* Customization and installation services
* Support for third party software or ANY kind of development whatsoever

Before seeking support, please...

* Make sure your question is a valid Software Issue and not a customization request
* Make sure you have read through the documentation and any related video guides before asking support on how to accomplish a task
* Make sure to double check the Software FAQs or online documentation
* Ensure that you access to the VBOM is allowed and that Macros can run in Excel
* Make sure to provide 'proof of purchase' and state the name / version of the Software that you are having issues with when requesting support by Email or via Facebook

How to get Support

Contact Mark Kubiszyn on the Email address provided when you purchased the Software, including the Order Number
Contact Kubiszyn.co.uk via our Facebook Page - remember to be patient, if there has been an issue with your download, I will always respond within 48 hours and will Email you the File directly if neccessary or via Messanger. For other issues the response time may be considerably longer and I may choose to respond to specific questions only (as is my right), depending on what has been asked

Version History (Changelog) #back to top

You can find the version history in the Code Module for any Macro-enabled Software or read more information below. The latest Version is always shown first

Changelog

29.06.2022 - (Version 9.1) Ruberduck Code Indentation & Inspection added.  Functionality added to allow the AddIn (or Code) to wait until the Workbook is activated and then automatically launch Kiosk mode depending on the configuration on the Settings Sheet.  Added the ability to Save the current Kiosk AddIn settings to enable the automatic launch of Kiosk mode and retain setup configuration for Kiosk.  Fixed the Bug on the Cursor being hidden only for Manual Borders.  Added the ability to NEVER hide the Taskbar if required as you may just want to make a small Manual Bordered Excel Window, hide some objects, but not hide the Taskbar so now this is possible

                                
01.05.2019 - (Version 9) an Excel Full Screen AddIn released - all other Versions are now deprecated!