CaptRon
01-11-2011, 11:02 PM
I have run into a problem (AGAIN!) with Excel 2007. When I place a text box on a sheet from the drawing toolbar in Excel 2003, I can set the properties to lock the text box and unlock text to allow users to enter text. I can even spell check the text box via VBA. Very cool. This workbook was originally built in Excel 2003 and functioned perfectly there.
Problem #1. Once I close the workbook and open it in Excel 2007, I can't enter anything in the text box. The properties have been reset by Excel 2007 to lock both the text box and the text. Opening it again in Excel 2003 doesn't help. I have to reset the properties in Excel 2003 to unlock text.
Something else that's odd. If I leave a text value in the text box (while I'm repairing it in 2003), Excel 2007 does not reset the properties to locked text. It works fine. But if the user ever empties the text box completely, closes it and re-opens in 2007, they can't access the text box. It's locked again. It's as though 2007 will automatically lock any empty text box but won't lock one with even a single text character in it.
I've tried using VBA to reset the text box properties on the sheet activate event and even though the property shows to be "unlock text", apparently it isn't. The result is the same. I can't insert anything.
Problem #2. So, I deleted that text box and used the textbox control (activeX) found on the Developer Tab in 2007. I can set the properties to lock the control while enabling text input and it works in both Excel 2003 and 2007. But now my spell checking code doesn't work. Can you even spell check an activeX textbox?
I need to find a solution for either Problem #1 or Problem #2. Any help will be greatly appreciated.
Man, I hope Excel 2010 is an improvement.
Ron
Problem #1. Once I close the workbook and open it in Excel 2007, I can't enter anything in the text box. The properties have been reset by Excel 2007 to lock both the text box and the text. Opening it again in Excel 2003 doesn't help. I have to reset the properties in Excel 2003 to unlock text.
Something else that's odd. If I leave a text value in the text box (while I'm repairing it in 2003), Excel 2007 does not reset the properties to locked text. It works fine. But if the user ever empties the text box completely, closes it and re-opens in 2007, they can't access the text box. It's locked again. It's as though 2007 will automatically lock any empty text box but won't lock one with even a single text character in it.
I've tried using VBA to reset the text box properties on the sheet activate event and even though the property shows to be "unlock text", apparently it isn't. The result is the same. I can't insert anything.
Problem #2. So, I deleted that text box and used the textbox control (activeX) found on the Developer Tab in 2007. I can set the properties to lock the control while enabling text input and it works in both Excel 2003 and 2007. But now my spell checking code doesn't work. Can you even spell check an activeX textbox?
I need to find a solution for either Problem #1 or Problem #2. Any help will be greatly appreciated.
Man, I hope Excel 2010 is an improvement.
Ron