LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Robert
 
Posts: n/a
Default import data greyed out when protection enabled

I have my sheet protected with only one column locked. This works fine but I
also want to be able to import data with protection enabled. When protection
is enabled, the import data commands are greyed out. The data that I will be
importing will not attempt to overwrite the column that is locked.
Is it possible to lock part of the sheet and import data?

thanks in advance,
Robert
 
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
How can I have the Import External Data dialog pop up on open? Benny Setting up and Configuration of Excel 1 November 19th 05 10:13 AM
import data to specific columns marlea Excel Discussion (Misc queries) 1 August 12th 05 02:05 AM
Data validation, cell protection or other method? KG Excel Discussion (Misc queries) 5 June 17th 05 05:22 AM
import external data from changing file name nathan Excel Worksheet Functions 2 April 6th 05 04:39 PM
import select data from another workbook schoeller Excel Worksheet Functions 0 March 31st 05 03:13 AM


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

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"