Unable to rename VBA Module in Excel for Mac

Question

James Palmer 280

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

0 comments

Answer accepted by question author

0 additional answers

Answer 1

Jeronimo Fuerte 45,585 Independent Advisor

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

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

James Palmer 280 Reputation points

2026-09-10T11:42:52.4633333+00:00

I finally found the Properties window. It appeared below the project window in the left hand side of the Microsoft Visual Basic window and it was almost completely hidden. All I could see was the top line and was able to drag it up to see where I could see/rename the module i had chosen.
James Palmer 280 Reputation points

2026-09-10T11:43:55.68+00:00

I finally found the Properties window. It appeared below the project window in the left hand side of the Microsoft Visual Basic window and it was almost completely hidden. All I could see was the top line and was able to drag it up to see where I could see/rename the module I had chosen.