will.lucas
09-02-2015, 12:21 PM
I am using a circular reference to create static time stamps when data is entered or changed (the event) in a table.
The circular reference allows iteration, I set the iteration parameter step and count . . . and this all works fine once the workbook is open.
This file is to be used as a template and I want to avoid the Excel warning popping up and making users concerned about the circular reference activity.
14296
I have tried to code into the workbook open event, but the error appears before this event is processed . . . or the code is ignored.
I have tried to send the escape key to acknowledge the warning pop-up automatically, but I need somehow to select the warning pop-up before sending the escape key to get this to acknowledge and close the warning.
How can I "Select" the Excel warning pop-up which occurs at wrokbook open and then send the escape key?
OR . . . anyone find a solution to preventing users having to acknowledge circular references built into the template file deliberately?
Thanks :think:
The circular reference allows iteration, I set the iteration parameter step and count . . . and this all works fine once the workbook is open.
This file is to be used as a template and I want to avoid the Excel warning popping up and making users concerned about the circular reference activity.
14296
I have tried to code into the workbook open event, but the error appears before this event is processed . . . or the code is ignored.
I have tried to send the escape key to acknowledge the warning pop-up automatically, but I need somehow to select the warning pop-up before sending the escape key to get this to acknowledge and close the warning.
How can I "Select" the Excel warning pop-up which occurs at wrokbook open and then send the escape key?
OR . . . anyone find a solution to preventing users having to acknowledge circular references built into the template file deliberately?
Thanks :think: