When I double click a cell, its contents are erased.

  • Thread starter Thread starter Maro
  • Start date Start date
M

Maro

Am not sure why this is happening. I have made an invoice creator with
Macros and Formulas. I am also protecting the sheet - locking cells except
for the ones I want to be able to edit. When i go to click on any unlocked
cell - its contents are immediately erased and the cell is blank.

I have no idea why this is happening.

Help is greatly appreciated.
 
Hi,

Save and close the workbook and re-open with macros disabled and see if the
problem goes away. If it does then find the macro that's causing the problem

Mike
 
PS the beforedoubleclick event for the worksheet would be a good place to
start looking
 
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

Keep contents of cell when clicking on it 7
Delete content of cell without erasing existing formula? 1
Excel Selected Cell's Content Magnification 3
HOWTO DELETE UNLOCK CELLS 3
Locked cells are still able to be selected with proper protection 1
Cell Protection Query 15
Why full contents of cell visible only by double clicking? 1
Hiding Formulas in Formula bar 3

Back
Top