Eval function without the morefunc add-in

R

rajat_magic

Board Regular
Joined
Sep 22, 2003
Messages
57
I have used the EVAL function in my spreadsheet. However, I will need to send this file to a number of people who probably don't have this add-in installed. Is there someway I can use this function without making it necessary for the user to have this add-in?

Thanks.
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Sort by date Sort by votes
rajat_magic said:
I have used the EVAL function in my spreadsheet. However, I will need to send this file to a number of people who probably don't have this add-in installed. Is there someway I can use this function without making it necessary for the user to have this add-in?

Thanks.
Click to expand...

You can invoke the following udf in VBA instead, which you need to add to your workbook as a module:

Function Eval(Ref As String)
Application.Volatile
Eval = Evaluate(Ref)
End Function
 
Upvote 0
Do keep in mind that access to the EVAL function was intentionally removed by MS as a major security risk. Are you sure you want to reinstate access for anyone who opens your workbook?
rajat_magic said:
I have used the EVAL function in my spreadsheet. However, I will need to send this file to a number of people who probably don't have this add-in installed. Is there someway I can use this function without making it necessary for the user to have this add-in?

Thanks.
Click to expand...
 
Upvote 0
tusharm said:
Do keep in mind that access to the EVAL function was intentionally removed by MS as a major security risk. Are you sure you want to reinstate access for anyone who opens your workbook?
rajat_magic said:
I have used the EVAL function in my spreadsheet. However, I will need to send this file to a number of people who probably don't have this add-in installed. Is there someway I can use this function without making it necessary for the user to have this add-in?

Thanks.
Click to expand...
Click to expand...

You need to elaborate this and also state whether it equally involves EVAL of the morefunc add-in. As far as I know, EVAL in Lisp is never considered a security risk, for example.
 
Upvote 0
Thanks guys. I also figured that if its available in VBA, it might be possible to define it as a name as well. Tried it, and its working...

Does anyone have any background on what kind of security risks this may lead to, and in what conditions? Thanks.
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
Application.Evaluate - unexpected results
2
Replies
16
Views
238
Jehannum_2000
J
M
  • Solved
How to move custom VBA/ribbons
2
Replies
12
Views
573
missingsc
M
M
  • Question Question
Protecting Sheet from users but permitting Power Automate
Replies
1
Views
439
ExcelToDAX
E
N
  • Question Question
Always open xlsx files in the already-open instance of Excel
Replies
2
Views
418
nevyoung
N
T
  • Solved
Filter Question
Replies
8
Views
121
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,224,260
Messages
6,177,490
Members
452,782
Latest member
ZCapitao

Share this page

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