LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Combo Box ListFillRange causing save prompt

I've seen a few posts of people with a similar problem, but I haven't
seen any solutions.

I have an Excel Workbook (Excel 2002) that contains a combo box. When
the ListFillRange property is populated I am prompted to save changes
every time I close the workbook - even when no changes have been made.
The ListFillRange values are static and contain NO formulas. I need to
prevent the save prompt from showing when no changes have been made.
Any suggestions?

One post mentioned setting the ListFillRange to blank unless the combo
box was activated. Does anyone know how to do that?

Thanks.

 
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
Save as .xls causing format loss Milan Bortel Excel Discussion (Misc queries) 0 November 6th 09 03:37 PM
Combo box - Listfillrange [email protected] Excel Discussion (Misc queries) 0 July 13th 07 09:51 AM
save prompt for user exit, but no save prompt for batch import? lpj Excel Discussion (Misc queries) 1 February 25th 06 02:08 AM
Combo Box ListFillRange Property - Non Adjacent Cells Tony_VBACoder Excel Programming 3 January 27th 05 03:54 PM
Loosing combo box ListFillRange Hank[_2_] Excel Programming 0 November 11th 04 05:53 PM


All times are GMT +1. The time now is 09:19 AM.

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

About Us

"It's about Microsoft Excel"