Import/Export XML in protected worksheet

J

jgentillet

I developped an excel tool on which most of the cells are protected (and I
need to keep them protected). I mapped an XML schema on all the worksheet
entries. I would like to be able to import and export all these entries but
Excel does not let me do that when the worksheet is protected. Can anybody
help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2010 - Save as XML 0
Cannot Import XML Spreadsheet 2003 with XML Data Source 0
XML Mapping 0
Enabling Autofilter and Sorting in a Protected Sheet 2
Protected Worksheet Tab Order 1
Protect and Unprotect all worksheets with macro 2
XML Schema 0
XML data import breaks cell formatting 0

Top