Tengo un MacBook Pro con el OSX Catalina en versión Beta y estoy usando la versión Office 365.
No soy un experto en Excel y menos en VBA en Excel, pero tengo el siguiente problema:
Estoy desarrollando un aplicativo para mis estudiantes en Excel 2016 para Mac. El aplicativo tiene objetos como el siguiente:
El archivo inicialmente fue creado en Excel para windows pero estoy intentando terminarlo en el Mac. No obstante al abrir el Editor de Visual Basic veo que está inhabilitada la siguiente opción:
El hecho de que esta opción esté inhabilitada me impide ver los objetos y su correspondiente código. Ya he reinstalado el Office 365 en dos oportunidades, completo, desde cero y el problema no se soluciona, no se activa.
¿Tienen alguna idea de porqué sucede esto?
Agradezco mucho la ayuda que me puedan brindar.
Jorge A. Echeverri
Jorge,
I was quite impressed with how well Bing Translate handled the translation of your Spanish inquiry into English. I hope that it does equally well for you in the other direction.
Mac Excel 2016 (including VBA) was completely rewritten to use the Cocoa API instead of the older Carbon API. At initial release, the VBA IDE in Mac Excel 2016 was missing so many features you could do little more than debug code written in Windows Excel (or Mac Excel 2011). If you have Office 365, many of the missing features were restored--but not all of them.
I have the Office Insider release of Mac Excel 2016/Office 365. It is more recent than your version, but the middle icon is still grayed out. On Windows Excel VBA, that icon returns you to the worksheet. In Mac Excel 2016 VBA, I click the yellow circle at the top left corner of the VBA window to minimize it and accomplish the same thing. Alternatively, if you leave a small portion of the worksheet window exposed, you can click on that to jump back to the worksheet.
The far left icon in Mac Excel 2016 VBA does take you to the code for the selected object. This was a feature I had never noticed before in either Windows or Excel VBA. My habit is to doubleclick the gray module icon in the Project Explorer (shaded gray in screenshot below) instead.
Hello Brad!
I very appreciate your response. I understand from the answer you give me that, because of my inexperience, I was not very clear with the question. I'm going to attach some screenshots from Excel for Windows in order to be clearer and help you help me.
In the image you see below I show with circles and arrows the items that I can see, and also edit (code), in Excel 365 for Windows but I CANNOT SEE, and LESS EDIT, in Excel 365 for Mac.
I tell you that I went to an iMac computer computer computer computer room in my workplace to check if this option was available in the Excel there installed, and I could check that that function is not active either, i.e. I can't SEE or EDIT my UserForm.
I hope this image obviously gives you more clarity to help me and I appreciate your response again and hope you can get an idea about my problem.
Grateful, Jorge Echeverri.