Activate Macros in a Shared Excel file

pamelarub

New Member
Joined
Oct 19, 2021
Messages
9
Office Version
  1. 365
Platform
  1. Windows
Hi guys,

I wonder if it's possible to activate VBA in a shared excel file. There's no a 'Macros' button under the 'View' tab.
Currently, I am only able to see the button of "Record Action" under 'Automate' which opens a screen for writing a script (I'm not familiarized to this and I don't know how it works), but is there the possibility to change the file from xslx to xlsm so I can add a Macro? If not, do you have any other solution?

Thank you any help or idea is really appreciated:)

1634707044334.png

1634707090324.png
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

johnnyL

Well-known Member
Joined
Nov 7, 2011
Messages
2,090
Office Version
  1. 2013
  2. 2007
Platform
  1. Windows
Go to file/Save As/ then select .xlsm under the the save as type..
 

Zot

Well-known Member
Joined
Nov 26, 2020
Messages
1,987
Office Version
  1. 2016
Platform
  1. Windows
Imagine a scenario that more than one person is using the workbook at the same time. That is why it is not really meant for shared workbook.

See if this discussion helps
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
67,826
Office Version
  1. 365
Platform
  1. Windows
VBA does not work with Office Online.
 

pamelarub

New Member
Joined
Oct 19, 2021
Messages
9
Office Version
  1. 365
Platform
  1. Windows
Thanks guys, referring to the discussion link that Zot provided. Based on my situation, do you think this would help? If so, do you know how to do it?
1634736535605.png
 

Zot

Well-known Member
Joined
Nov 26, 2020
Messages
1,987
Office Version
  1. 2016
Platform
  1. Windows
I have no idea on Excel 365, but as @Fluff said no VBA for online Office. I've never done shared document myself too :)
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,588
Messages
5,765,303
Members
425,271
Latest member
kristyfinn

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
Top