.Net ADO, Protect and Track Change
Problem 1:
The data from Database and the application server has no MS office
installed. We have to use the .Net ADO to insert data and create worksheet.
It works fine.
Not quite sure to understand your problem as you say that it "works fine2...
Problem 2:
The protection is down to cell, so all of the cells is protected but only
some are allow to make modification. It works fine too but only Marco enable.
How I can do it without Marco enable?
There is a cell "locked" cell property
Format - cells - protection
Problem 3:
My client require "Track Change" enable, it seems not possible to be enabled
by the VBA code. Also it is conflict to enable protection and "Track change",
i.e. if "Track Change" enabled, VBA execute protection will cause error. What
I can do?
Don't know about this one... sorry..
--alexT
|