warning

Hello, The code below works but only after the warning pops up. I get a critical warning pop up that says "No Such Template". Can anyone see why the warning pops up first then actually does what the macro is supposed to do? <code> Sub OL() Dim objOL As Outlook.Application, msg As MailItem...

Hello, The Personal.xlsb Macro file on my system is set to open automatically when Excel Opens (in the XLSTART folder) and is hidden from view, so that it is accessible for me to code and write to without having to manually open it. Normally, this is not an issue, but it has been an on again /...

Hello. I am building a form/calculator in Excel ('13). I have inserted 3 option/radio buttons for the user to select between. By default, Excel has configured the output of these 3 buttons to a defined cell, when checked, to be 1, 2, and 3 respectively (which is exactly how I want to use them. I...

I have about 20 files and each of them have links to external sources. I open all the files together. Each file is opened with the following warning massage: "This workbook contains links to one or more external sources that could be unsafe. If you trust the links, update them to get the latest...

I have a line of code that sets a workbook variable to each workbook in a folder and then runs some additional code over each workbook. Occassionally I will get an error (Run time 1004) on the line below. If I try to open the workbook throwing the error it almost always has an unreadable...

Hi everyone, I have a VBA code which creates (and formats) a scatter chart from 7 columns and 3000 lines of data. Every time when the chart is created I get a warning box: "Complex formatting that is applied to the selected chart may take a while to display. Do you want to continue to use the...

Hi I'm running a macro that gets a file from the internet. My code is like this: (i got it recording the macro) With ActiveSheet.QueryTables.Add(Connection:= _ "TEXT;https:// here my url..." _ , Destination:=Sheets("mysheet").Range("$A$1")) .Name = "the name here"...

Does anyone know how to get rid of the warning that comes with Macros? It is something to the effect of a warning of potential hazards of opening a document with Macros. A lot of the spreadsheets I work on I need to distribute and people get scared of opening or changing settings in excel when...

I have a question about whether certain Excel options can be set as default, or otherwise be made 'sticky' so that I don't have to set them again and again when opening the same spreadsheet. I believe the question is generic, but in this case I am using Excel 2007 SP3 MSO and running on Win7...

Hey guys, Http://www.sendspace.com/file/pjb29x I'd appreciate if you help build a macro with a series of warning, depending on meeting (or not) certain conditions. I have a table Http://www.sendspace.com/file/pjb29x, where I have 3 groups of columns: 1. First group...

I've got a control macro in Excel VBA that opens a database in Access, runs an Access macro, then closes the DB, before carrying on with Excel and running off a load of reports. Dim A As Object Set A = CreateObject("Access.Application") A.Visible = False A.OpenCurrentDatabase...

Hi all, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I have a userform with a listbox and some options buttons. <o:p></o:p> <o:p></o:p> the user will select an item from the listbox, select their option (Add, Remove, Edit, View). Their...

I have a worksheet named "Template". The template worksheet has to be copied as a new worksheet with a different name to enter any values. I do not want my users to accidently enter data in the Template and save. To avoid this, if the user tries to enter data in the "Template" worksheet, I want...

I'm not an excel expert but I am a fast learner and do enjoy excel But I'm struggling with this: I8 has this formula =-(BUDGET!C54) which is the beginning budget amount I9 has this formula =SUM(I12:I50) which is total of the expenses entered I10 has this formula =I8-I9 which is the difference...