mac 2011

does anyone know hot to solve the following. if a is true then the result is the number, if b is true (or a is false) the result is the number times 10, im supposed to use a sub, and it must be done in such a way that only executing the macro will compute the result for every #...

Hello experts, I am having issue with a scatter plot graph that I am trying to make in excel. I am comparing woodpecker holes to the elevation at which they were found at. I was told by my instructor to place the holes on the y axis and the elevation on the x axis. However, in doing so I am...

I have the following VBA code that works great in Excel 2013 (Win) but when I try to use it on Excel 2011 (Mac) the workbook tries to reopen and I receive errors. Is there any way to modify this code to work on the 2011 version? The code uses the BeforeRightClick event handler to show a list of...

Hi, After hours of working with Excel for Mac, their help documents and many visits to this forum, I am requesting the experts help. In the image below, I have a Pivot Table which shows column C (% conversion) that I am currently getting from the Pivot Table. The values that I want to get are...

Hi, I would like to code something simple to automate the following process: <colgroup><col><col><col><col></colgroup><tbody> Survey Period Normalized Score Diff vs Preop IDK 1 pre-op 63.89 6 wk 97.22 97.22-63.89 12 wk 100.00 100-63.89 24 wk 100.00 100-63.89 52 wk...

Hello, I am trying to get some code to work on a mac, and am getting a Run-time error '5' invalid procedure or argument on line 18 "Value=Dir(Folderpath, &H1F)" I realize that this means that some part of that code is not available in Excel 2011 for Mac, but am unsure which part and was...

I am trying to send a multiline email using a macro in Excel 2011. The problem is that it isn't sending a separated lines it just ends up all bunched together. Can anybody give me any help? This is what I have right now Sub MailBody() 'Generate Email Address emadd = "" & UserName &...

Hello, I am trying to find a way to send an email from excel (no attachment needed just text), but it needs to send from an alternate email address than the one that I would be using in Outlook or Apple Mail. I created one that works on Windows by sending it with CDO, but the same code doesn't...

I just recorded a macro that I saved to my Personal Macro Workbook on my mac computer with Excel for Mac 2011. I want to share this with my co-worker who has a PC with Excel 2007. I saved the file with the macro recording saved as an .xlsm and then e-mailed it to him, but we couldn't figure out...

Hi i have a recent problem with excel, when I enter a whole number with no decimal point, it automaticly moves the decimal point two spaces. I have un-instaled and re-instaled excel in my mac, but it keeps doing it. Example if I enter 5, it shows .05 if i enter 100, it shows 1.00 but if i...

Hi guys, I have a VBA compiled which works fine on PC, but don't know if it works for Mac. Can anyone help me? As you can see, the website is a password protected one, so I'd just need the syntax checked. PS: Crosspost here...

Hey folks, interesting problem here. I have an order form that users fill out and send in using VBA. I must avoid the original file being saved over and prompt the user to saveas if they haven't saved a copy of the workbook since they opened it. I want to be able to give the user the option...

Hi All, I have an excel document with three sheets in. The sheets that require attention are "Sheet 2" and "Sheet 3". Basically "Sheet 2" is pulling data from "Sheet 3". "Sheet 2" is laid out differently to "Sheet 3" as it is the sheet that is used for printing the data. So I have set up a...

Hi! Can anyone help me here? I have a userform that has a button for BROWSING a photo (but no code yet) and I want that photo to be posted on the same userform. Then I want those information in my userform to be posted to a NEW SHEET. Kindly help me please... Thanks a lot!

I am running VBA code in Mac 2011 Excel. It opens files that are password protected on servers pulls info from each of those files into one MASTER. I can get it to run fine on my machine, however when my client runs the code, it prompts him for passwords to files (even though I address that in...