View Single Post
  #4   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've removed the protection and unhidden all the
sheets. I've also copied and pasted one of the cells in question into a new,
blank workbook and the text box thing goes with it. If anyone wants to see
what I'm talking about it I could email it over.
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