Unable to rename VBA Module in Excel for Mac

James Palmer 280 Reputation points
2026-09-09T14:20:04.9333333+00:00

I have tried to find workable instructions on how to rename a module with no success.

I know I have been able to name/rename modules before, but can't seem to repeat my efforts.

Help appreciated.

JP

Microsoft 365 and Office | Excel | For home | MacOS
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jeronimo Fuerte 45,585 Reputation points Independent Advisor
    2026-09-09T18:25:38.7866667+00:00

    In Excel for Mac, you can rename a VBA module from the Properties window in the Visual Basic Editor.

    1. Open Excel and go to Tools > Macro > Visual Basic Editor.
    2. In the Visual Basic Editor, select View > Project Explorer if the Project Explorer is not already visible.
    3. Expand your workbook's VBAProject, then expand Modules.
    4. Click once on the module you want to rename, for example Module1.
    5. Select View > Properties Window.
    6. In the Properties window, find the (Name) property.
    7. Replace Module1 with the name you want and press Return/Enter.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.