excel 2013 macros

My company just "upgraded" to office 2013 and now one of my macros that ran perfectly in 2010 now seems to have a handful of issues. 1.It runs at a fraction of the speed ,2010- ~15 seconds per account vs 2013 ~ 1 minute per account.I have already tried disabling Animate controls and elements...

hi there! im a school registrar, could someone teach me how to put macro on my worksheet: 1. encoded a rows of student details (e.g. First Name, Middle Name, Last Name, age, sex etc.) in sheet 1. 2. in the same sheet (sheet 1) a botton or control to create a new sheet (in the same workbook)...

Hello all and thanks in advance, I wonder if it is possible to create a macro, and if so how, that tells excel ,that everytime that changes in the sheet get saved , send an email to a certain outlook account. That would help heaps to fix some comunication problems that happen in the company...

Good Evening All, I currently have 1 master workbook that has data inputed into it daily, all the cell/s information changes except for the headers. The 1st of 28 Headers is titled "Engine SN" and has the serial numbers of 58 engines automatically inputed once the raw data has been calculated...

Hi, Have been using the forums for a long time for various excel related tips and help. However I cannot find a solution to my current problem and want your help. :) I have to mail multiple people, both in "To" and "CC", with each mail containing a separate PPT. Now, I have found macros for...

I am working in Excel 2013. I am trying to create an UserForm for my department for formatting reports that we create that don't come out "Pretty" I have a few text boxes for things like freezing the sheet on XX, print titles, naming sheets, etc etc At the bottom of the user form, I have a...

Hello, In Excel 2013, it was not possible to scroll in a worksheet after using a userform. With some help from this forum I found the option userform modeless. This fixed the scrolling problem but creates a new problem: screenupdate = false doesn't work any more. Can anybody help how to fix...

Hello all, I wonder if you could help me please? I am in the process of creating a worksheet but i feel like i have hit a brick wall. I am using Excel 2013, I have a workbook with 8 sheets in. I have one sheet where all the main data is and then i have a further 7 sheets of various stages...

I Got this error in excel 2013, previously i was working in excel 2007, the code was working perfectly. in excel 2013 i receive this massage " The Linked image cannot be displayed the file may have been moved, rename Or Delete. Verify that the link points to the correct file and location. I have...

Hi guys, I need to create a macro to copy cells from a column to multiple sheets. For example, i need to copy A1 from sheet0 to sheet1, A2 from sheet0 to sheet2, A3 from sheet0 to sheet3 etc What i need to do is sort of a reverse summary I need to do this for 1000 sheets. I am using Excel...

The Big Picture: I am a casting director making appointments for actors in Excel. The times for their appointments are specific. Three sheets labeled as follows: 1) "Master sheet" for calling out appointments and times for all actors being considered 2) "Not interested in the appointment" 3)...

Hello, I have a few macros that work well in pivot tables in Excel 2013. For instance they adjust all titles in the pivot table, or set all value items to sum - simple but helpful macros like that. Macros are found on internet or books and adjusted to make them work for my situation. Using pivot...

Hi We have had a few instances where Excel 2013 is truncating a filename when saving for example "MF Not Settled - Dec 13 Rental A.." the filename includes additional characters than this but has replaced them with .., I initially thought it could be a file path length issue but the files in...

I've come across this behavior on two different occasions now. I have a workbook that is password protected for write access. I've written a macro and assigned it to a shape. In Excel 2010 I am able to execute the macro without any troubles both in Read-Only as well as Edit mode. When I open...

I am trying to access the text that is entered inside of a textbox object with a VBA macro. My macro breaks when I attempt to execute it, generating the message "Run-time error '438' - Object doesn't support this property or method". My macro (simplified, but still generates error as written)...

I have just moved from a laptop running XP/Excel 2007 to a laptop running Windows 8 64-bit/Excel 2013. I have a .xlsm file that contains a macro which prints various sheets from the graph into 7 pdf files stored in other folders. The part of code that creates (i.e. overwrites the existing...

I just loaded Office 2013 on my PC, but still have my trusty 2010. I have a lot of workbooks with VB macros in them that work fine in Excel 2010. But they won't run in 2013. I get this error message: "Run time error '1004': The password you spplied is not correct. Verify that the CAPS LOCK...