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