Lock Column in Excel 2000

T

tg

I have a non-Microsoft program that exports data into Microsoft Excel
2000.
I have it setup so after the data is exported into Excel, I insert a
column.
In the new column, I put a function (for the same of example,
Let's say it is in column 'c', starting in row '5', =a5*b5.
There are many columns of
Data after column c.

Is there any way to setup up a template Excel file, so that column c in
Excel is
"locked" (or whatever the term for this is), so the data is
exported to
columns 'a', then 'b', then skips c, then the next column is
'd', then column 'e', etc.
I have to run a number of reports like this every day and would make
life much easier!
 
P

Pete_UK

The program which creates the data would need this template, unless it
exports a text file which you then import.

If you import the data through the Text Import Wizard, then you could
record a macro while you do this once. The macro could also unlock all
cells, insert a new column C, lock the cells in column C, enter the
formula and copy it down then apply protection with the password
written into the macro. Subsequently, you would only need to invoke the
macro to do this automatically each day.

Hope this helps.

Pete
 
Top