ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   importing on protected sheet? (https://www.excelbanter.com/excel-worksheet-functions/74098-importing-protected-sheet.html)

Robert

importing on protected sheet?
 
When I protect only one column on a sheet, the import functions are greyed
out. I have a sheet with only column K protected and want to be able to have
others import from a text file that will fill column A thru H. Is there a
workaround or is this by design?

thanks,
Robert

Dave Peterson

importing on protected sheet?
 
You didn't like yesterday's suggestion to your post in .misc.

Robert wrote:

When I protect only one column on a sheet, the import functions are greyed
out. I have a sheet with only column K protected and want to be able to have
others import from a text file that will fill column A thru H. Is there a
workaround or is this by design?

thanks,
Robert


--

Dave Peterson


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

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