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

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.
 
M

Mike H

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
 
M

Mike H

PS the beforedoubleclick event for the worksheet would be a good place to
start looking
 

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
Cell Protection Query 15
Why full contents of cell visible only by double clicking? 1
Click on cell to increment contents by 1 3
Change Single-Click Functionality? 2
Double click in a Cell 1
Formula in Excel does not work until after I double-click inside c 7
Stop Scrolling When I double-click cell wall 5

Top