View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_3_] Dick Kusleika[_3_] is offline
external usenet poster
 
Posts: 599
Default Protect Microsoft Query

Don

Protecting the sheet will protect the query. Tools - Protection - Protect
Sheet.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Don" wrote in message
...
I am inporting data using a query.
Is there a way of protecting that query so a user cannot
modify it?
It appears that anyone can go to Dataedit query and
change it.
Thanks - Don