Have been using a workbook for a long time now, which contains a couple of combo box and a spinner form control.. I have completely removed O365 from my Mac and reinstalled from the O365 portal, but the problem persists.
Each control is set up as follows: Spinner, slider controls, cell immediately above is linked and a macro is assigned - the macro has one command - Msgbox 'Hello' The command button has the Hello macro assigned The combo and list boxes are set up to get their items from 3 cells on the sheet containing 'Item 1', 'Item 2' and 'Item 3'.. Clicking on the combo drop-down arrow button has no effect (no drop down), so a selection cannot be made, nor does the Hello macro execute.. However I've just returned from leave this week and was greeted with a Microsoft Office update (as I have been in the past and which I accepted. excel comments not displaying properlyexcel comments not displaying properly, displaying comments in excel, comments not displaying in excel, how to show all comments in excel, why are my comments not showing in excel, excel comments not displaying g Win 7, O365 2013) Bitfinder for mac review Even if this has been done and the list is populated an item cannot be selected, nor does the Hello macro execute.. So maybe it's not so bad:~ Immediately after updating Excel et al to 15 18, I started Excel, loaded my workbook and tried my controls, but got no response (including, as I said, the command button control).. I am running Excel, version 15 17 (151206) I have a colleague who is still running 15.. My workbook worked correctly as recently as 18 Dec 2015 Method 1: Make sure that toolbar display is not turned off. Fontlab For Mac Free Download
comments not displaying in excel
why are my comments not showing in excel
However, I also use a Worksheet_BeforeRightClick() macro on one of my worksheets and I found that this wasn't working.. Clicking on the spinner and slider controls produces no change in the linked cell, nor does the macro run to produce the Hello message box.. However, I now find my spinner and combobox form controls no longer work Clicking on them produces no response.. This time I find that the controls are now all working properly as does my Worksheet_BeforeRightClick, macro.. Pdf converter for mac 3 So, giving the benefit of the doubt, I quit Excel and restarted.. 16 and the test workbook controls function normally I have also tried the same workbook in Windows 7, running O365 2013 and a legacy version of Mac Office 2011, both of which function normally.. I have had a colleague who is, like me, running 15 17 try the workbook and he found that the controls did not work.. They are also assigned the Hello macro which should execute when a selection is made/changed.. The command button controls still seem to work correctly I have created a new test workbook with each of the controls available from the Developer menu and found that only the command button is working.. The listbox does not display the associate items (Item 1, 2, 3), unless it has been opened in a version/platform of Excel that does work (e. e828bfe731
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |