Personal macro buttons not working on latest build of O365 Excel (Version 1707 Build 8326.2076)

L33

Board Regular
Joined
Jul 2, 2008
Messages
108
Hi,

My company has Office 365 E5 subscriptions for all it's staff, but as this is a recent thing only a few people have so far been given access to obtain the latest updates from Microsoft. I'm in this small group, but believe I'm the only one who uses Excel extensively, including the use of a Personal.xlsb macro file. I have several buttons on a couple of custom ribbons and on the QAT bar that are assigned to macros in that file.

Since I was upgraded to Version 1707 Build 8326.2076, my Personal.xlsb file, which still resides in my XLSTART folder, doesn't open automatically, and even when I open it manually, none of the buttons will work. My IT department's only solution is to roll my edition back a version - but that's not a solution!

Anyone have experience of this or have any ideas? (I'm wondering if my company's security policies are too stringent and affecting things like this unintentionally, but I can't pin down the root cause or how to overcome it).

Any advice gratefully received.
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Forum statistics

Threads
1,224,823
Messages
6,181,184
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

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