Is there an add-in that will lock the cells like later versions of Excel?

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

I'm using 97 and for 99.9% of everything I do I works fine except I can't
lock cell format so there can only be data entry. I would be nice if I
could do that.

Marc
 
Hi Marc,
Can you be more specific about what you want and don't want.
 
I've set the borders, the fill color etc. I want to be able to enter data
but if I need to clear, copy and cut the formatting is unaffected.

Marc
 
You must log in or register to reply here.

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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Is there a way to lock out the format for the cell and still allow data entry and C&P? 1
Locked cells in Excel 1
Excel Excel: locking refererence cells 2
locking text in a cell, but allowing new text to be added 2
Locking specific cells 1
Lock out data entry in a cell 1
Still can select locked cells in protected sheet 11

Back
Top