Cannot Insert Procedure Into VBA (EXCEL 2013)

quarinteen 1

Hello all, I am trying to write a script for Excel 2013. I opened the VBA module and under the project I inserted a module for the procedure. When I try to add the procedure it is greyed out. The file is saved .xlsm. Anyone have any idea?

Viorel 112.5K Reputation points

2021-02-24T11:54:58.047+00:00

Where is it greyed out, in code editor window?

If you remove private data or prepare a new Excel file that shows the issue, publish it (for example, on OneDrive), then maybe someone who has Excel 2013 will be able to reproduce and investigate the problem on other machines.

1 answer

Elizabeth Damilola 10 Reputation points

2023-01-16T16:46:52.6+00:00

Click on view code and try to add the procedure, it should work. Screenshot 2023-01-16 174558.jpg
Please sign in to rate this answer.

2 people found this answer helpful.
Eggs 1 Reputation point

2024-03-14T22:03:33.2733333+00:00

This worked for me.
Sign in to comment