ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   cannot get into previously created text box, nor can I create new (https://www.excelbanter.com/excel-discussion-misc-queries/156772-cannot-get-into-previously-created-text-box-nor-can-i-create-new.html)

Patti

cannot get into previously created text box, nor can I create new
 
Grrrrr. Created a text box in a wksht that I have been using for about two
weeks. Suddenly today I can't access the text box. If I even move my cursor
OVER the text box, my cursor changes to a circle with a slash through it
(like no smoking, no parking, etc.) So obviously I have ****ed off this
worksheet somehow. I can't enter text, I can't click on it to delete it. If
I click on the Insert Tab like I want to insert a new text box, it's grayed
out so I can't. What gives??? And why is Office 2007 Help so lame???

Thanks for letting me vent.
P.

Roger Govier[_3_]

cannot get into previously created text box, nor can I create new
 
Hi Patti

Sounds like the sheet is protected.
Right click on sheet tabUnprotect

--
Regards
Roger Govier



"Patti" wrote in message
...
Grrrrr. Created a text box in a wksht that I have been using for about
two
weeks. Suddenly today I can't access the text box. If I even move my
cursor
OVER the text box, my cursor changes to a circle with a slash through it
(like no smoking, no parking, etc.) So obviously I have ****ed off this
worksheet somehow. I can't enter text, I can't click on it to delete it.
If
I click on the Insert Tab like I want to insert a new text box, it's
grayed
out so I can't. What gives??? And why is Office 2007 Help so lame???

Thanks for letting me vent.
P.




Patti

cannot get into previously created text box, nor can I create
 
Thank you Roger, for responding. I finally figured out that somehow I had
clicked Sheet 2 as well, creating a "Group," something I had not intended to
do, especially since I had no idea that I COULD do that. I had to click on
Sheet 3 (not part of the group) to clear out the group, then my sheet was
normal.

Thanks again,
Patti

"Roger Govier" wrote:

Hi Patti

Sounds like the sheet is protected.
Right click on sheet tabUnprotect

--
Regards
Roger Govier



"Patti" wrote in message
...
Grrrrr. Created a text box in a wksht that I have been using for about
two
weeks. Suddenly today I can't access the text box. If I even move my
cursor
OVER the text box, my cursor changes to a circle with a slash through it
(like no smoking, no parking, etc.) So obviously I have ****ed off this
worksheet somehow. I can't enter text, I can't click on it to delete it.
If
I click on the Insert Tab like I want to insert a new text box, it's
grayed
out so I can't. What gives??? And why is Office 2007 Help so lame???

Thanks for letting me vent.
P.






All times are GMT +1. The time now is 10:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com