ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Import data into protected worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/227666-import-data-into-protected-worksheet.html)

RalphM

Import data into protected worksheet
 
I would like to import external data into unlocked cells in a protected
worksheet.
The data from an external piece of test equipment is always in the same
format, so I have blocked out cells for the import. These cells are
unlocked. The formulas to analyze the data are to be protected. When I
protect the sheets, the DATA import function is grayed out, so I can't
import. Is there some way to do what I want?
--
RalphM


All times are GMT +1. The time now is 12:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com