Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveX control causes "Reset project" notice on file open
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveX control causes "Reset project" notice on file open
I have the exact same problem. Is there anyone out there that has a
solution?!? Mahonri "GeoBrooks" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveX control causes "Reset project" notice on file open
I've noticed you've posted this all over the web. If you get a solution,
Could you send it to me if it is not posted here? davidt(a_t)aristatek(d_ot)com Thanks "GeoBrooks" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveX control causes "Reset project" notice on file open
The only solution I found was starting over in a fresh workbook. I had a
recipe for reproducing the error, but it was only good on my system. I guess it's nice to know my situation was not unique. fwiw, here's the recipe: 1. Cells: A1 = 1, A2 = 2, B1 = A, B2 = B 2. Insert ActiveX combobox somewhere on sheet 3. Combobox properties: a. Column count: 2 b. Column widths: 0;43 c. LinkedCell: A4 d. ListFillRange: A1:B2 4. Make selection from combobox to get entry in Linked cell 5. Save, close then reopen. No error. 6. Change combobox name. 7. Save, close, reopen. Error: €śThis action will reset€¦€ť Good luck. Be nice to know if you find a solution. George "Mahonri" wrote: I've noticed you've posted this all over the web. If you get a solution, Could you send it to me if it is not posted here? davidt(a_t)aristatek(d_ot)com Thanks "GeoBrooks" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Excel Discussion (Misc queries) | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Setting up and Configuration of Excel | |||
ActiveX Control with Dialog Causes "Lock" | Excel Programming | |||
How to control "Date Time Picker ActiveX Control" | Excel Programming |