Sometimes the find (ctrl f) doesn't work correctly? In an Excel spreadsheet and using the Ctrl F Find box, it almost always works fine but once in a while it will say there are no matches when there is a match. My client has a product based on Excel spreadsheets (2003- compatible) that we are porting to the Mac targeting Office 2011. Track changes tutorial word 2010. These files using a significant amount of VBA code to check for valid licenses, perform functions, etc. We have been using.xls files but find that there are a number of problems with compatibility, including.xls files that compile fine on the PC but blow up when transported to the MAC due to subtle differences between the two, that I have been unable to code around (so far). It was suggested that we using either.xlsm format or.xlsb format rather than.xls to work around these problems and reduce file sizes. This turns out not to work very well as we are using an ActiveX image control to 'veil' sheets in the workbook until the license is verified. This works fine in the ported.xls file, but immediately causes an error in the.xlsm and.xlsb format with the message that 'ActiveX is not supported and the workbook will now be read-only'. The VBA code proceeds to happily check the license, hide the ActiveX image 'veil' (that Excel just claimed was not supported) and display the sheet. The veil is used because MAC users have the option of turning off Macros, which means that any active means of preventing a user from seeing the content won't work. The passive mechanism ensures that they turn on Macros and pass a license check before they see any content. Is there any other way of putting an image in front of the content on the spreadsheet that does not involve Macros? Preferably, how do we get the ActiveX image, which works fine with.xls format to work with.xlsm or.xlsb and to turn off the bogus Read Only message? All suggestions welcome. Thanks, Neil. ![]() I have the new 2013 MacBook Pro. I have purchased Microsoft Office for Mac, which is what I'm using when I say 'Mac Excel' I am a power excel user in PC Excel but am having a hard time in Mac's excel, as many of the Mac excel shortcuts don't work. For instance, to edit active cell, in Windows its an easy 'F2' shortcut, in Mac excel, ^+U (shift +U) isn't working. In fact, none of the shortcuts (with the exception of the most basic like cut and paste (Ctrl+C, Ctrl+V in Windows) are working. I switched my command button to be my control button, since I'm so used to the PC keyboard layout, but I always press Mac's CONTROL when a shortcut indicates to use the squigly square COMMAND button. I just don't understand why the most basic shortcut like ^+U to edit an active cell isn't working in my Mac excel. So frustrating! Thank you for any tips on how to fix the Mac excel problem with Mac shortcuts not working. I have just done a little experimenting and I think I have some idea of why you're having a problem. I opened up Mac Excel 2011 and selected a cell. I pressed Control-U and I was able to edit it. I also pressed F2 and I was again able to edit it. So I'm starting to think that there is a configuration problem somewhere on your Mac. On Control-U: I am wondering if this no longer works on your Mac because you remapped Command to Control. Because in Mac Excel, Command-U (apply underline formatting) and Control-U (edit selected cell) are two different features, so if you remapped Command to Control at the system level, Excel now behaves such that all Command-modifier shortcuts are now Control. Therefore, Command-U (underline text) is now Control-U, and whatever was Control-U before (edit active cell) is disabled since a shortcut can only mean one thing at a time. That's my theory on why Control-U stopped working for you: You told the Command-U feature (underline text) to replace the former Control-U feature (edit active cell). One possible way to fix this is that because remapping Command to Control eliminates access to Control key shortcuts, you could also remap Control to Command so that you can regain access to shortcuts that need the Control key like Control-U. Basically you would be swapping the two keys. (I think that would work, anyway) But ultimately my recommendation is that if you bought a Mac intending to commit to the Mac.then really commit to the Mac. Stop trying to use the Control key and learn the Command key so that in applications that make use of both Command and Control shortcuts, you don't lose an entire set of shortcuts when you remap. On F2: If pressing F2 changes your screen brightness instead of editing the active cell, then there is a setting you can change. Open System Preferences, click the Keyboard icon, click the Keyboard tab in there, and select the setting 'Use all F1, F2, etc. Keys as standard function keys.' When you do that, F2 will now function as F2 and not as screen brightness adjustment.
0 Comments
Leave a Reply. |