View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JustBreathe JustBreathe is offline
external usenet poster
 
Posts: 22
Default Prompting user to answer a question before saving and closing wkbo

Hi,

I would like for the users of my excel workbook to provide a percent
complete update before saving and closing the file. Is there a way to have a
custom dialog box pop up when they attempt to save or close? Can this box
ask them to select a percentage complete choice from either a drop down box
or radio button selection? I would appreciate any assistance in pointing me
in the right direction or getting me started on this idea I'm trying to
implement.

TIA,
Tanya