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
Last Comment
Lawrence Salvucci
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
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.
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