My application is creating an xml file which is about the same format
which is used to create excel file. This xml file is read by a VB
application(whose code I do not have). The VB app creates a xls file
and password protects the same.

The change which I wanted to carry out was:
For one of the cells, I would like the contents to be displayed in the
formula bar, even if the user has opened the excel sheet in the read
only mode (without the password)

If I want to try this out in excel I would need to follow the below
steps
a)Right Click on the cell
b)Format Cells -Protection-Hidden checkbox should be unchecked

As per MS documentation, this can be acheived by making the following
changes in the XML File
1) In the style for that particular cell, we need to put in the
attribute
<Protection x:HideFormula="0" ss:Protected="1"/
2) In the worksheet tag we need to put
<Worksheet ss:Name="Sheet1" ss:Protected="1"
instead of
<Worksheet ss:Name="Sheet1"

Now if I give this modified file to the VB app, it throws up the
following error:

Run-time error '1004': Unable to set the FormulaHidden property of the
Range class

What are the changes I would need to do in XML to resolve this issue.
Please note: I cannot use macros or that kind of stuff due to customer
restrictions.


--
ydnam
------------------------------------------------------------------------
ydnam's Profile: http://www.excelforum.com/member.php...o&userid=33554
View this thread: http://www.excelforum.com/showthread...hreadid=533363