LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 75
Default Protecting a Microsoft Query

Good morning,

I have an Excel file that links to an Access database to retrieve the
information via Microsoft Query. I want to protect the Microsoft Query from
the users going into it.

How do I protect my Microsoft Query from the users going in and messing
things up? I have a protection on the workbook "Structure". However, if the
user has an External Data toolbar, they can click on the Edit Query button to
go into the query.

Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Query from microsoft query- Excel 2007 טבלאות אקסל 2007 Excel Discussion (Misc queries) 0 December 24th 07 10:47 PM
Microsoft Query SB Excel Discussion (Misc queries) 4 July 26th 05 01:30 PM
Microsoft Query rejects "nz" function in Access Query Vaughan Excel Discussion (Misc queries) 0 May 4th 05 05:20 PM
Microsoft Query gsteck Excel Programming 5 March 25th 05 08:35 PM
Protecting my VBA based query programming Astra Excel Programming 4 March 11th 05 03:37 PM


All times are GMT +1. The time now is 11:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"