Unusual macros

tiredofit

Well-known Member
Joined
Apr 11, 2013
Messages
1,907
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Does anybody know what these two macros are?

I didn't create them and all the options on the right, including Edit, are greyed out.

Thanks



1726223041872.png
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
They aren't macros as such. They are for backwards compatibility of excel functions, in your case the LET function.
You can delete them, although they may reappear.
 
Upvote 0
Thanks for the replies.

Can you tell me how they got there? I certainly didn't put them in.

I normally add Option Private Module to all my modules, so the macros table is blank.

How can I remove these two?
 
Upvote 0
Just select them & click delete.

They come automatically when you use certain functions, but are normally hidden.
I can't delete.

All the options on the right, as shown in the screenshot, have been greyed out.
 
Upvote 0
Do you have any LAMBDAs defined in that workbook?
 
Upvote 0
You need to go into the Name Manager on the Formula tab to delete them.
 
Upvote 0
Honestly I don't know what those are then. the _xleta prefix is for eta reduced lambda functions but I've never seen one appear in the macros dialog before.
 
Upvote 0
You need to go into the Name Manager on the Formula tab to delete them.
Thanks.

They were indeed in the Names Manager.

I deleted them there, then checked in Macros but they still remain.
 
Upvote 0

Forum statistics

Threads
1,221,526
Messages
6,160,338
Members
451,637
Latest member
hvp2262

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top