ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Force Input when opening file (https://www.excelbanter.com/excel-programming/375099-force-input-when-opening-file.html)

Pernod

Force Input when opening file
 
I have 3 cells that have a valadation list in each. How do make a message or
prompt screen appear when opening the file that forces the user to select one
of the choices.

Ron de Bruin

Force Input when opening file
 
Hi Pernod

You can use a event that run when you open the workbook

Read this page
http://www.cpearson.com/excel/events.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Pernod" wrote in message ...
I have 3 cells that have a valadation list in each. How do make a message or
prompt screen appear when opening the file that forces the user to select one
of the choices.





All times are GMT +1. The time now is 11:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com