Using clear text boxes as cell protection.
Posted by Tony on January 06, 2000 4:02 PM
In Excel 4, I used to draw a clear, unfilled text box over cells that I didn't want users to access. It worked like a protected sheet of glass that if you clicked on it nothing would happen. After upgrading to Excel98 I have tried to no avail to make this work. Yes I remembered object and worksheet protection. It only seems to work for me if the text box is fill with color or text, which won't work for me in this case. Any Ideas? Thanks in advance.