Menu
Visual Basic macros are no longer supported in Excel 2008 for Mac, which might make things a little difficult for you if you're used them a lot in the past, or if somebody else gives you spreadsheets using them. The Microsoft Office for Mac team shows you just how to deal with Visual Basic macros in this how-to video. Since Office 2008 removed support for Visual Basic macros, see one way to get around this limitation. After watching this video, you'll be able to:. Understand the limitation associated with Visual Basic macros in Excel 2008. Use Excel 2004 and Excel 2008 at the same time to work with Excel workbooks that contain Visual Basic macros.
One of the easiest ways that I can think of is to save the Excel file as.xlsx instead of.xlsm. That will remove all macros. Besides that, open the Visual Basic Editor and go into each sheet within the project and delete everything and then make sure that all modules are deleted.
![Excel Excel](/uploads/1/2/5/4/125491700/796822494.gif)
MonicaRYU wrote: 'how do i remove the active x from an xl file? I'm unable to use the macros, buttons etc, on my xl file on a mac that was created on a pc.' I develop VBA add-ins using Windows Excel and then test on Mac Excel. I avoid Active-X controls and always use Windows-Mac-compatible Forms controls.
Disclaimer: I have never had to remove Active-X controls, and I cannot speak from experience. If I ever did have to remove an Active-X control, I would use the Visual Basic Editor in Windows Excel.
![How to remove visual basic macros in excel for mac 2008 How to remove visual basic macros in excel for mac 2008](http://excelsemipro.com/wp-content/uploads/2010/09/Name-Range-with-Name-Box-1.png)
If I wanted to replace an Active-X control with a Forms control, then before removing the Active-X control, I would examine and make a note of the properties of the Active-X control, e.g., name, height, left, top, width, etc. Then I would delete the Active-X control, create a Forms control, and try to replicate the behavior of the Active-X control using a Forms control.