demofindmy.blogg.se

Select excel file that works both for mac and windows vba
Select excel file that works both for mac and windows vba










select excel file that works both for mac and windows vba

For how to check VBA code in Excel for Mac, you can go to Excel > Developer > click Macros > select the macro name then click Edit, then you will see VBA code. On the other hand, if the suggestion above doesn’t work, you can also share the related VBA code and we will help you move this thread to related category and engineers in that category will try their best to help Select the folder in which the file is saved Click the file type drop-down menu and select Text Files Select the extractlist.txt& click on Open button Text Import Wizard will be opened. If so, on the one hand, you can contact the creator of this file to refer to the suggestion HansV provided to check if he used ActiveX command buttons, if so, he can replace the buttons with Form Controls command The next step is to open Microsoft Excel Click on File & Open to bring up the Open dialog window or press Ctrl-O shortcut key. We appreciated that you posted back and confirmed the scenario above with us.Īnd per your description, it seems that you will contact the creator of this file and deliver this information. * Kindly Mark and Vote this reply if it helps, as it will be beneficial to more community members reading here.

select excel file that works both for mac and windows vba

Sukie - * Beware of scammers posting fake support numbers here. Your supervisor to replace the buttons with Form Controls command buttons to check if the same problem will occur. If you want, we will help you move this thread to Excel/Microsoft Office programming/ Office 2016, that’sĪ specific channel to handle related questions, you can post your VBA code and the engineers will help you check if you need to change any VBA code.Īt the same time, you can also refer to the suggestion HansV provided to let Given the situation you encountered, this issue may be related the compliance between VBA code in Excel for Windows and VBA code in Excel for Mac. For example, Active-X Controls will not beĪvailable on Excel for Mac. However, some macro codes may not be supported in Excel for Mac. If my understanding is right, generally, we can run the macro codes in an Excel for Windows file with the Excel for Mac application. Thank you for your message in this forum.Īccording to your description, it seems that you have used VBA code to custom-create button in Excel for Windows, then you can went to Excel for Mac and opened this file, you found that you cannot use those custom-create buttons with VBA code.












Select excel file that works both for mac and windows vba