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

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.

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

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

"Maro" wrote:

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.

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

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

"Mike H" wrote:

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

"Maro" wrote:

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.