I have a number of spreadsheets that I have created and are populated by Access.
However I want to set these as Read only when they are opened by users, but retain Write properties when exporting data from Access
This is the command I am using to export the data to my spreadsheets
stQryName = "All Internal Ncr by Customer Qry"
DoCmd.TransferSpreadsheet (acExport), acSpreadsheetTypeExcel9, stQryName, "\\server\Databases\Internal NCR\Spreadsheets\All by Customer.xls"
Is there a simple command that I can add to make the spreadsheet read only, but still allow me to export access data to it.