Hi

I have done as you suggested but the protect sheet button is greyed out and
will not change.

Any more ideas please ?

"JLatham" wrote:

It sounds like the worksheet is protected. Try going to the Home tab and in
the Format group click the Cells button and look and see if (near the bottom
of the list) if under {Protection} there isn't an entry that says Unprotect
Sheet.
If there is, click that and hopefully it will work for you. If there is
just an entry that says Protect Sheet, then this is not the problem.
If Unprotect Sheet is there (odd place to put Protect Sheet - in the Format
Cells area, but there it is) then when you click it, it may ask you for a
password which you will have to provide to get your buttons/functions
available to you again.

"PollyP" wrote:

Can anyone tell me why some of my icon buttons are greyed out and how i can
get the back. For instance i am unable to insert a comment as this is greyed
out.
I cannot filter data as this is greyed out.

Anyone any suggestions please. This has only happened on one spreadsheet so
far but think it may happen again.