Optimize Time In Filling Cells
right click on sheet tabview codeinsert thissavedouble click on cell.
You probably want to restrict cells. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target = "" Then Target.Value = 0 ElseIf Target = 0 Then Target.Value = "" End If End Sub -- Don Guillett SalesAid Software "rfs04" wrote in message ... Hello all, Does anybody know if it's possible to make excel putting a cross or a circle or whatever in a cell only by clicking on it and if you click again it disappears?? Maybe its science fiction? Thanks in advance. --- Message posted from http://www.ExcelForum.com/ |
All times are GMT +1. The time now is 11:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com