Avatar of Lawrence Salvucci
Lawrence Salvucci
Flag for United States of America asked on

Preventing Users from opening Connection Properties & Refresh All in Excel Menu

I have a workbook that is shared by multiple users and I want to lock down access to the "Connection Properties" and the "Refresh All" buttons on the Data menu. I have the worksheet password protected but those two options are not grayed out when I protect the worksheet. Should they be? The "Queries & Connections" is also accessible even when I password protect the worksheet. How can I prevent users from accessing these options on the data menu?
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Lawrence Salvucci

8/22/2022 - Mon
Ryan Chong

How can I prevent users from accessing these options on the data menu?

I got something similar too.

But I ended up using macro to refresh the connections. And replace it with "Dummy" connection properties once the refreshing is done. So that when user wants to manual refresh it, it will prompt error and cannot be proceed.

Hope that make sense
Lawrence Salvucci

View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck