Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,868 questions
Unable to access the Worksheet window in Visual Basic editor in Excel (Microsoft 365) on Mac with error message "Variable uses an Automation type not supported in Visual Basic"
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 67%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBG%3C/text%3E%3C/svg%3E)
Brian Gormley
0
Reputation points
Long time Excel user, but new to VBA. Attempted to copy VBA code to sort a worksheet into the VB Editor Worksheet window. VBE would not open the Worksheet widow and produced the error message "Variable uses an Automation type not supported in Visual Basic." Error message appears regardless of which existing Excel file VBE Worksheet widow I try to open and even in new blank workbooks. There is no user entered VBA code in any of the workbooks in which I've tried to access the Worksheet window. I completely uninstalled MS 365 on my Mac and reinstalled it, but the error still appears. I had previously (before deleting and reinstalling MS 365) copied the code into one Excel file on my MAC, but I had deleted the code and saved the file after deleting it.
Can anyone tell me how to overcome this problem?
Excel
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,880 questions
Sign in to answer