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
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.
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