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!
-
Congratulations MintJulep 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
- Thread starter yakpol
- Start date
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
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
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.
- Thread starter
- #5
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
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
SkipVought
Aerospace
Do your have all the necessary Object Libraries referenced in Tools > References... in your VBA Editor?
Skip,
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
Just traded in my OLD subtlety...
for a NUance!![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
Skip,
Just traded in my OLD subtlety...for a NUance!
- Thread starter
- #8
SkipVought
Aerospace
And....?
Skip,
Just traded in my OLD subtlety...
for a NUance!
Skip,
Just traded in my OLD subtlety...for a NUance!
Is it possible to post a copy of the offending workbook here?
Doug Jenkins
Interactive Design Services
Doug Jenkins
Interactive Design Services
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question