10-18-2014 04:07 AM
I need to protect an excel worksheet, and I use "USERINTERFACEONLY"
As i also require some formatting such as merge cells and other option I use "ALLOWFORMATTINGCELLS"
But I'm not able to run it... it say unlock and than run....
I do not want to unlock do modification and than lock method...
Is there an alternative???
10-18-2014 08:19 AM
karthik9 a écrit :
I need to protect an excel worksheet, and I use "USERINTERFACEONLY"
As i also require some formatting such as merge cells and other option I use "ALLOWFORMATTINGCELLS"
But I'm not able to run it... it say unlock and than run....
I do not want to unlock do modification and than lock method...
Is there an alternative???
It would be a lot easyer to help you if you attach your code.
Ben64
10-21-2014 03:15 PM
@karthik9 wrote:
I need to protect an excel worksheet, and I use "USERINTERFACEONLY"
As i also require some formatting such as merge cells and other option I use "ALLOWFORMATTINGCELLS"
But I'm not able to run it... it say unlock and than run....
I do not want to unlock do modification and than lock method...
Is there an alternative???
I don't understand the problem. As I understand it, you have protected your Excel Worksheet. That means that you can't modify it without unlocking it. So why is it a problem to require you to unlock it, modify it, then re-lock it?
The alternative, of course, is not to lock it in the first place.
10-23-2014 10:40 PM
Sorry for the long delay...
Now the reason for protection is ..... The Excel sheets updates like every 30 Seconds and this should be visible to the User...
But the User should not modify anything....
The "UserInterfaaceOnly" option helps in doing this.... But as the Excel sheet has to be formatted a bit ("Cannot use Tempelate due to reasons") Merge Cells,Font Color.... Does not work... Which causes an Error to Pop UP....
But as I've seen through various other blogs where people use VB script this problem is solved by setting "AllowFormattingCells" to true....
This doesn't work for me in LABVIEW??????
10-24-2014 08:11 AM