pop-up

Hello, this query is more for my curiosity than need. I'm using 2007 and Win XP. What code do I use to answer yes to a popup generated by a macro? The popup occurs when I move sheets that have a vlookup formula into another workbook that has the same formula. The popup asks, "YES" or "NO", if I...

Hi I'm tying to send a Excel generated mail with attachment from Outlook, but get this security message: A program is trying to automatically send e-mail on your behalf. Do you want to allow this? If this is unexpected, it may be a virus and you should choose "No". Excerpts from the code I'm...

Whenever I try to trace the dependents on a cell that has no dependents, I get a pop-up that says "The Trace Dependents command found no formulas that refer to the active cell". Previous versions of Excel didn't have this popup. How can I suppress it? Thanks

Is there a way to create Pop-Up Alerts/DialogBox - based on a cell value - (kind of conditional formatting) ... ?

Hi all, Back again i'm afraid with more help needed. I've got a Macro that, when activated, allows the user to cancel a demand and highlight that row red when completed, here's the code: Sub Cancel_DMD() Dim datatoFind, sRemark As Variant Dim sheetCount As Integer Dim counter As Integer Dim...

I'd like to display a pop-up message on startup for an Excel file. The message would simply give a brief 3-step on how to use the file (calculations, etc.) I've created pop-ups to validate cells before, but not this. Anyone have a way for me to do this? Thanks.

Hello all, I have a table (tblDatabase_Rocks) where details of field-collected samples are entered into via a form (frmRocks). Each record has a unique Primary Key field (SiteNumber). These are entered into the txtSiteNumber control on the frmRocks. Occasionally, an address will need to be...

I have seen this trick before but am unsure how to do it. I have data in a table in a worksheet and have a chart created in the same worksheet. I would like to be able to click on a cell (or some point) in that worksheet and have the chart pop up over top of the data in the same worksheet. Then...