View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
drewship drewship is offline
external usenet poster
 
Posts: 13
Default SQL to unprotect and protect worksheet

Hello all.
I have 2 SQL queries that automatically import data from an Access database
into 2 different sheets on my spreadsheet when the spreadsheet opens. I need
to unprotect the sheet prior to the import, then protect it after the import.
I have looked at several posts but they all have to do with macros. Any help
would be appreciated.

Thanks in advance!!
Andrew