View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
GaudiGill GaudiGill is offline
external usenet poster
 
Posts: 4
Default Mystery text box I can't edit

Hi John,
Thanks, but that's not it. I have unprotected the sheet and unhidden all
hidden sheets. I have even copied one of the cells into a new workbook and
the text box thing comes with it.
Anyone else any ideas??
Gill




"john" wrote:

Have a look at toolsprotection to see if the sheet is protected. Also there
might be a hidden sheet so check formatsheetunhide
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"GaudiGill" wrote:

Hi everyone,
I'm working on a spreadsheet that someone else has developed.
When certain cells have the focus, a text box appears next to the cells
which contain instructions on what to enter into the cells. I need to edit
these boxes, but I can't select them and nothing happens when I right click
on them. They look a little like comment boxes or text boxes, but only
appear when the cells they are associated with have the focus and not on
roll-over. Also they cannot be edited in the review facility and there is no
mention of them in the VB code.
I'm sure someone out there knows what these are. If so, please help.
Thanks
Gill