Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

UDF will not run in Excel 365

Status
Not open for further replies.
yakpol

yakpol

Structural
Joined
Jun 1, 2001
Messages
450
Location
CA
I was surprised to find that UDF do not work in the latest MS office worksheet. UDF name appears on the list after typing "=" sign, but then it becomes unrecognized (#NAME?).
If anybody encountered it and managed to solve? Thanks!
 
Sort by date Sort by votes
From mintjulep's second link:

Macros aren't required for everyday use like reading or editing a document in Word or using Excel workbooks. In most cases you can do everything you need to do in Office without allowing macros to run.

Which is really irritating, even by Microsoft standards, but if you go down to the bottom of the link and unhide the text on what to do if you are sure the file is safe, it does actually give some helpful advice.

Doug Jenkins
Interactive Design Services
 
Upvote 0 Downvote
Does MS yet offer graded access to macros? Like limiting macros to only making changes to the active document and not getting the entire OS access including reaching the network and the internet? This business of allowing a macro enough access to obliterate an organization from a Word document seems like an obvious flaw. At least they should have allowed an "examination" mode where the macro is available to be edited, but cannot run, so a user knows if it's something that makes a useful change or is intended to cripple a company.

 
Upvote 0 Downvote
Thank you for replies. I will try to change properties of the file. Doubt it's going to help. The file I am using has plenty of macros and they run fine. But UDF does not. Wonder if there's a way to register, so it may act as native function.
 
Upvote 0 Downvote
If its only UDFs that don't work and all the other macros do then it can't be due to macros being disabled.

Do all UDFs show this behaviour?

Was this change in behaviour after a Windows or Office upgrade?

I use Office 365, with lots of UDFs, but I haven't had this problem (yet).


Doug Jenkins
Interactive Design Services
 
Upvote 0 Downvote
Do your have all the necessary Object Libraries referenced in Tools > References... in your VBA Editor?

Skip,

[glasses]Just traded in my OLD subtlety...
for a NUance![tongue]
 
Upvote 0 Downvote
Sorry for troubling. This UDF does not work only in one particular workbook, but just fine in all others.
 
Upvote 0 Downvote
And....?

Skip,

[glasses]Just traded in my OLD subtlety...
for a NUance![tongue]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

K
  • Locked
  • Solved
Macro not running
Replies
2
Views
2K
koubaleite
K
C
  • Locked
  • Question Question
InserVariable is not recognised
Replies
2
Views
1K
Denial
Denial
Sidtha
  • Locked
  • Question Question
Export Bundle Segnment Properties to excel
Replies
0
Views
2K
Sidtha
Sidtha
William Heath
  • Locked
  • Question Question
change active cell in excel
Replies
4
Views
1K
IDS
IDS
Susangrizly
  • Locked
  • Question Question
How I circunavigated the problem with excel adding quotes to text
Replies
0
Views
794
Susangrizly
Susangrizly

Part and Inventory Search

Sponsor

Back
Top