Invisible typing!!
Hi, I use Excel 2003 in Win 7. I use a workbook with multiple worksheets to maintain various records for a Scout Group. On only one sheet, I have suddenly found that, when I type anything into any of the cells (ie letters or numbers) the typing within the cell is invisible until I press Enter or move to another cell. As I type, I can see the narrative in the editing bar (above the columns). I wondered if anyone might advise me how to fix this? It looks as though I have inadvertently created some sort of formatting, but I'm blowed if I know how to correct things!
I have checked: 1 Font colour selection is black and definitely not white! 2 Cell formatting is fine - nothing sinister that I can see. 3 Sheet and book is unprotected (only I ever use it!) Thanks for any help, it is much appreciated. Mike |
Invisible typing!!
Hi Mike,
Am Wed, 19 Nov 2014 09:33:14 +0000 schrieb MikeC2909: 1 Font colour selection is black and definitely not white! 2 Cell formatting is fine - nothing sinister that I can see. 3 Sheet and book is unprotected (only I ever use it!) check Conditional Formatting also and press Alt+F11 to look into the VBA Editor if there is code that makes this issue. If you can't find the error send the sheet to me: claus_busch(at)t-online.de Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
Quote:
I'm not sure what "conditional format" means, and your reference to VBA is, I'm afraid, meaningless to me!! You asked if I would send the sheet to you - I can't send the entire sheet as there is some information on there that I'd prefer to keep confidential. But, I've copied the rest of the sheet into a new worksheet - and that has the same problem. However, I regret your email address is not being accepted..... MIke |
Invisible typing!!
Hi Mike,
Am Wed, 19 Nov 2014 13:00:50 +0000 schrieb MikeC2909: You asked if I would send the sheet to you - I can't send the entire sheet as there is some information on there that I'd prefer to keep confidential. But, I've copied the rest of the sheet into a new worksheet - and that has the same problem. However, I regret your email address is not being accepted..... you have to replace (at) with @ Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
A public thank you for your help, Claus. Now sorted.
Quote:
|
Invisible typing!!
Hi Mike
Am Wed, 19 Nov 2014 16:18:21 +0000 schrieb MikeC2909: A public thank you for your help, Claus. Now sorted. always glad to help. You are welcome Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
All times are GMT +1. The time now is 02:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com