disable connection and query ribbon by vba

Ofir Dinelton 0 Reputation points

Hello everyone,

I have a file that makes several queries to other excel files and to a SQL server using PowerQwery.

I want to prevent users from accessing or editing/deleting the query.

How can I prevent access or disable connection and query ribbon with VBA Code in an unprotected file

I know it is possible by protecting the file, but I would like to check how this can be done in an unprotected file


A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,075 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,034 questions
0 comments No comments
{count} votes