I am trying to use AppleScript to manipulate Mac Excel 2011 files on a Macbook Air running OSX Mavericks. I also have Parallels installed with Windows 8.1 and Windows Excel 2013. I'm using Excel 2011 for Mac rather than Parallels and I've never really got any macros to work the same way as I expect them to on a Windows machine. What is stored in your variable 'file_name', when it tries to save? The reason I ask is that Macs use a different file path structure to Windows.

One of my all-time favorite keyboard shortcuts in Excel is CTRL+Home, but on a Mac there is no Home button. Hence a constant source of frustration these last two years. I finally decided to do something about that and recently figured out a solution using VBA and the Personal Macro Workbook. But before I go straight to the answer, let me tell you how I got there. My Journey I knew that VBA was going to enter into the equation, so I started to record a macro on a Windows PC while using the Control+Home keyboard shortcut. What I found out is that Excel does not record that keyboard shortcut.

Nothing, nada, zip. I then noticed that Control+Home acted differently, depending if the sheet panes were frozen or not.

When sheet panes are not frozen, the Control+Home shortcut took me to cell A1. When the sheet panes are frozen, then the upper left corner cell of the window was selected. To make a long story short, I found out that the active window’s scroll row and column were being selected when the CTRL+Home shortcut is executed in Excel for Windows. The Control+Home Macro I also knew that if a Chart sheet were selected the macro would fail, so I crafted the following macro to mimic the CTRL+Home shortcut on a Mac. (Works on a Windows PC too.) Sub GoHome() ''''''''''''''''''''''''''' ' Make sure the active sheet is a worksheet, ' then locate the active window's scroll row and ' column, and activate that cell. ''''''''''''''''''''''''''' Dim lngRow As Long Dim lngCol As Long. If ActiveSheet.Type = xlWorksheet Then lngRow = ActiveWindow.ScrollRow lngCol = ActiveWindow.ScrollColumn Cells(lngRow, lngCol).Activate End If End Sub The next thing I did was create a shortcut for the macro, but realized that the macro would only work with the current workbook.

I wanted the macro work automatically on every Excel file so I chose to store this macro in the Personal Macro Workbook, which solved the problem. However the shortcut key combination I assigned did not work in Excel for Mac. Free gmail app for mac. There was a conflict. It seems that COMMAND+OPTION+H is a reserved keyboard shortcut for the Mac.

In this particular version of Outlook the Outbox only becomes visible during send. If the above don’t work, please provide your Outlook for Mac client version details and Mac OS version details for further analysis. Outlook for Office 365 for Mac Outlook 2016 for Mac Outlook 2019 for Mac More. Outbox Stop an email from being sent.  When you're online and email works normally, you won't see the Outbox. The Outbox appears at the top of the sidebar only when messages are waiting to be sent. Outlook for mac outbox. I have Outlook Mail all set up but i cannot find the Outbox folder nor anyway to add it. Does somenone know anything about this? Close Outlook, To open, double click on the icon while holding down the shift button. Upon opening, the outbox appears at the bottom on the folders column.

I found out this shortcut hides all windows except the one that is active. How I Created the Control+Home Keyboard Shortcut on my Mac Here are the steps I took, with a few false starts along the way.• Open Excel 2011 and choose Tools > Macro > Record New Macro • Type a name for the macro. I used GoHome. • Enter a Shortcut key.