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: 12
Default Problem doing Query to Access with Excel sheet protected

Hello All

Subject sort of says it all. I have a macro that does an MSQUERY to an Access database, prompts for a company name,
pulls the record with the matching company name into the Excel sheet into the appropriate row. However, it is not
working with the sheet protected. The cells being written to are not locked or hidden. I'm not sure if it is the query
not getting done, or the writing of the data to the Excel sheet.

Thank you

Harry

 
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
Add tab access to check boxes in a protected Excel sheet form. Suebriquet Excel Discussion (Misc queries) 0 July 25th 07 07:12 PM
Vlookup problem with Access Query import into Excel 2000 Neophyte New Users to Excel 4 July 17th 06 03:31 AM
Linking workbook and range protected Excel sheet to Access richiverse718 Excel Discussion (Misc queries) 0 March 20th 06 11:51 PM
Query Into Protected Sheet - Excel 2000 on WinXP Home (SR2) FredC[_2_] Excel Programming 0 September 11th 04 06:12 PM
Problem with excel linking to Access query JamesJ[_2_] Excel Programming 0 April 13th 04 12:36 PM


All times are GMT +1. The time now is 09:45 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"