Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robert
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default 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
Reply
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
List, Data Validation, unlocked cell, protected sheet..... Kane New Users to Excel 6 July 16th 12 09:11 AM
Protected Sheet Message tlosgyl3 Excel Discussion (Misc queries) 2 December 8th 05 08:13 AM
Applying autofilter to protected sheet Brian Ferris Excel Discussion (Misc queries) 2 November 18th 05 04:28 PM
Protected sheet to unprotected sheet [email protected] Excel Worksheet Functions 2 October 26th 05 05:30 PM
Copying multiple sheets from one book 2 another and undertake spec Pank Mehta Excel Discussion (Misc queries) 14 March 16th 05 04:41 PM


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