Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-19-2019, 07:47 AM
PrincessApril PrincessApril is offline Macros in Office 365? Windows 10 Macros in Office 365? Office 2019
Advanced Beginner
Macros in Office 365?
 
Join Date: Nov 2019
Posts: 30
PrincessApril is on a distinguished road
Default Macros in Office 365?

Hi all,



Our office just updated to Office 365, and we no longer have access to the desktop versions of Office apps.

I have an Excel workbook with macros important to its functionality, but it appears that in 365, no macros are allowed.

Is there an alternative to achieve VBA functions in Office 365's online Excel app? I find it hard to believe that people all over the world will no longer be able to use their spreadsheet VBA functionality when moving to 365... (at least, I'm hoping to hear other news--what a soul crushing blow!).
Reply With Quote
  #2  
Old 12-20-2019, 05:00 AM
macropod's Avatar
macropod macropod is offline Macros in Office 365? Windows 7 64bit Macros in Office 365? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,760
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
Default

Quote:
Originally Posted by PrincessApril View Post
I have an Excel workbook with macros important to its functionality, but it appears that in 365, no macros are allowed.
Macros are fully supported in Office 365. Maybe your IT Admins have implemented group policies preventing them.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 12-20-2019, 08:06 AM
PrincessApril PrincessApril is offline Macros in Office 365? Windows 10 Macros in Office 365? Office 2019
Advanced Beginner
Macros in Office 365?
 
Join Date: Nov 2019
Posts: 30
PrincessApril is on a distinguished road
Default

Hmm interesting. That is possible. We have to maintain HIPAA compliance, so I wonder if that's involved here. I'll check. Thank you Paul.
Reply With Quote
  #4  
Old 12-20-2019, 08:12 AM
PrincessApril PrincessApril is offline Macros in Office 365? Windows 10 Macros in Office 365? Office 2019
Advanced Beginner
Macros in Office 365?
 
Join Date: Nov 2019
Posts: 30
PrincessApril is on a distinguished road
Default

Looks like macro functionality is only disabled in the browser-based app, but we do have access to the Excel 365 (app?) as a desktop version, where my macros appear to live on.
Reply With Quote
  #5  
Old 12-20-2019, 01:35 PM
macropod's Avatar
macropod macropod is offline Macros in Office 365? Windows 7 64bit Macros in Office 365? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,760
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
Default

The Web app edition of Office 365 doesn't support the creation, running, or editing of macros. Not only that, the web editions are limited in other areas, too. See:
Office for the web service description - Service Descriptions | Microsoft Docs
Word for the web - Service Descriptions | Microsoft Docs
Excel for the web - Service Descriptions | Microsoft Docs
OneNote for the web - Service Descriptions | Microsoft Docs
PowerPoint for the web - Service Descriptions | Microsoft Docs
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #6  
Old 01-01-2020, 06:03 PM
PrincessApril PrincessApril is offline Macros in Office 365? Windows 10 Macros in Office 365? Office 2019
Advanced Beginner
Macros in Office 365?
 
Join Date: Nov 2019
Posts: 30
PrincessApril is on a distinguished road
Default

Those are useful links--thank you Paul. I did notice some of the limitations in Word when I was working on some projects a while back.
Reply With Quote
Reply

Tags
office 365, vba

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros in Office 365? After A Reinstall of Office, My Macros Get Multiple Errors Stephen Ray Word VBA 8 10-03-2018 11:10 AM
Disable all macros with notification - Office BUG !!! AndyF Word VBA 0 05-26-2016 07:36 AM
Macros in Office 365? Macros on Office 2011 for Mac kemsonj Word 6 10-25-2012 11:58 AM
Macros in Office 365? This macros are not working in office english version 2007 hans Excel Programming 4 12-10-2011 07:03 AM
office 2000 cant accept 2007 macros vinayak koli Excel 0 02-11-2009 05:53 AM


All times are GMT -7. The time now is 07:31 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft