Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Force a number input Gunti Excel Discussion (Misc queries) 2 February 5th 09 11:18 AM
How to force cell input from a List? NightLord Excel Discussion (Misc queries) 3 September 27th 08 01:24 AM
Opening a file with User Input [email protected] Excel Discussion (Misc queries) 3 March 28th 07 03:00 AM
Opening a file through input of first 3 digits Just4fun Excel Programming 23 June 26th 04 09:16 PM
Opening a text file for input [email protected] Excel Programming 5 January 8th 04 05:11 AM


All times are GMT +1. The time now is 03:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"