| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a double click event for cell? | Excel Discussion (Misc queries) | |||
| Double click to navigate to a cell | Excel Discussion (Misc queries) | |||
| Cell contents with custom time format rounded after double-click | Excel Discussion (Misc queries) | |||
| Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
| Double click in a Cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
