• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

disable edit functionality in table

Hello, and welcome to the forum! :awesome:

You can go to Review - Protect Sheet, which should disable that option.
 
Thanks for the prompt response. However, protecting sheet would also not let me refresh data. I have a excel query received from external data from server in table format. I want my staff to refresh and use the data but I do not want them to edit the query. They play around quite abit with the query.
 
You can use VBA code to run the query I suppose.

Something like below.
Code:
Sheets("sheetname").Unprotect Password:="password"
ActiveWorkbook.Connections("connection name").Refresh
Sheets("sheetname").Protect Password:="password"
 
I think Chihiro's on the right track. I'd put a button on the sheet of interest and assign that macro to it. Still lets everyone refresh the query, but not they can't edit it.
 
Back
Top