LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 24
Default ActiveX control causes "Reset project" notice on file open

Update:

If saved as an XL2003 workbook and opened in 2003, there are no reset
messages. If the 2003 workbook is opened in 2007 there are no reset
messages. If the 2003 workbook is saved as .xlsm and opened in 2007 the
reset messages reappear.

So, why?

G

"GeoBrooks" wrote:

I've added two combobox controls to an XL2007 macro-enabled workbook because
I needed to capture their values b4 they were changed. Now when the workbook
is closed, then reopened, I get two "This action will reset your project..."
messages on opening.

I know I can prevent the messages by changing the state of "Notify Before
State Loss" in VB. I need to be able to prevent these messages before
distributing the workbook. How can this be done?

Thanks.

Geo

 
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
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. Phillip Pi Excel Discussion (Misc queries) 0 April 23rd 09 08:53 PM
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. Phillip Pi Setting up and Configuration of Excel 0 April 23rd 09 08:53 PM
ActiveX Control with Dialog Causes "Lock" pagates Excel Programming 0 March 8th 06 08:17 PM
How to control "Date Time Picker ActiveX Control" Jafery Excel Programming 1 July 21st 05 02:38 PM


All times are GMT +1. The time now is 06:41 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"