Share via

disable connection and query ribbon by vba

Ofir Dinelton 0 Reputation points
2023-11-19T19:28:46.0333333+00:00

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

Thanks

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,017 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.
4,066 questions
0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.