Hello all,
I have two questions; things that are frustrating me!

1. I'm working on a spreadsheet in Excel 2003 -- it's already been built,
formulas/functions are already in place. I'm not an 'expert' on Excel, I
know enough to make people nervous though :-)
This file as one worksheet, and I want to add another one, but "add
worksheet" is greyed out. From what I can tell, it's not protected. (I also
cannot move/copy the worksheet)

2. There are little text boxes EVERYWHERE in this sheet. It's driving me
nuts, when I'm trying to select a cell, I keep getting text boxes, I delete
one and another pops up! I bet there are 15 of them in some of these cells.
Is there some way I can select ALL the text boxes (these have no text in
them, btw, so they are invisible till I click on em) and delete them? Why
or HOW did all these irritating boxes show up?

Thanks for your help!
G.I. dunno

OOPS, I screwed up.
The workSHEET is not protected, but the workBOOK is.
Whoever created this spreadsheet is long gone -- any idea how I can crack
into it so I can add another sheet?
This shouldn't effect deleting all the stupid text boxes (IF I can find them
all)

Thanks again!

"GIdunno" wrote:

Hello all,
I have two questions; things that are frustrating me!

1. I'm working on a spreadsheet in Excel 2003 -- it's already been built,
formulas/functions are already in place. I'm not an 'expert' on Excel, I
know enough to make people nervous though :-)
This file as one worksheet, and I want to add another one, but "add
worksheet" is greyed out. From what I can tell, it's not protected. (I also
cannot move/copy the worksheet)

2. There are little text boxes EVERYWHERE in this sheet. It's driving me
nuts, when I'm trying to select a cell, I keep getting text boxes, I delete
one and another pops up! I bet there are 15 of them in some of these cells.
Is there some way I can select ALL the text boxes (these have no text in
them, btw, so they are invisible till I click on em) and delete them? Why
or HOW did all these irritating boxes show up?

Thanks for your help!
G.I. dunno

one way to get rid of text boxes is to Edit-Go to-special select objects
hit OK

and push backspace
note this gets rid of all of them
you can deselect individuals by holding down control and clicking on them

if you google microsoft passwords you winds many entries. both free and ones
you have to pay for. Since it is known that some free ones have had viruses
in them take care if you use one.

"GIdunno" wrote:

OOPS, I screwed up.
The workSHEET is not protected, but the workBOOK is.
Whoever created this spreadsheet is long gone -- any idea how I can crack
into it so I can add another sheet?
This shouldn't effect deleting all the stupid text boxes (IF I can find them
all)

Thanks again!

"GIdunno" wrote:

Hello all,
I have two questions; things that are frustrating me!

1. I'm working on a spreadsheet in Excel 2003 -- it's already been built,
formulas/functions are already in place. I'm not an 'expert' on Excel, I
know enough to make people nervous though :-)
This file as one worksheet, and I want to add another one, but "add
worksheet" is greyed out. From what I can tell, it's not protected. (I also
cannot move/copy the worksheet)

2. There are little text boxes EVERYWHERE in this sheet. It's driving me
nuts, when I'm trying to select a cell, I keep getting text boxes, I delete
one and another pops up! I bet there are 15 of them in some of these cells.
Is there some way I can select ALL the text boxes (these have no text in
them, btw, so they are invisible till I click on em) and delete them? Why
or HOW did all these irritating boxes show up?

Thanks for your help!
G.I. dunno

Thank you! I bet there were at LEAST 500 text boxes!
I'm off to look for the passwords now.

"bj" wrote:

one way to get rid of text boxes is to Edit-Go to-special select objects
hit OK

and push backspace
note this gets rid of all of them
you can deselect individuals by holding down control and clicking on them

if you google microsoft passwords you winds many entries. both free and ones
you have to pay for. Since it is known that some free ones have had viruses
in them take care if you use one.

"GIdunno" wrote:

OOPS, I screwed up.
The workSHEET is not protected, but the workBOOK is.
Whoever created this spreadsheet is long gone -- any idea how I can crack
into it so I can add another sheet?
This shouldn't effect deleting all the stupid text boxes (IF I can find them
all)

Thanks again!

"GIdunno" wrote:

Hello all,
I have two questions; things that are frustrating me!

1. I'm working on a spreadsheet in Excel 2003 -- it's already been built,
formulas/functions are already in place. I'm not an 'expert' on Excel, I
know enough to make people nervous though :-)
This file as one worksheet, and I want to add another one, but "add
worksheet" is greyed out. From what I can tell, it's not protected. (I also
cannot move/copy the worksheet)

2. There are little text boxes EVERYWHERE in this sheet. It's driving me
nuts, when I'm trying to select a cell, I keep getting text boxes, I delete
one and another pops up! I bet there are 15 of them in some of these cells.
Is there some way I can select ALL the text boxes (these have no text in
them, btw, so they are invisible till I click on em) and delete them? Why
or HOW did all these irritating boxes show up?

Thanks for your help!
G.I. dunno