Keep Sheet Unprotected but protect some cells

[Dave69rock]

Hi

I Need to protect some cells from being Changed or deleted, if i protect the whole sheet there are some cells that need to be changed using the formatting bar I.e borders, colours, font- colour, Merged cells.

the protection setting allows you to leave individual cells unprotected however you still cannot change the border for example.

Is there anyway around this

Dave

[royUK]

Which version of Excel are you using?

[Dave69rock]

its for work and they are still using 97

[royUK]

There's not much you can do except write a mcro to unprotect the sheet then do the format, finally protecting the sheet. Maybe suggest i's time for an upgrade!

[Dave69rock]

The Upgrade i've asked for many times now the credit crunch!!! it may take a while.

I'm using a macro already to unprotect and protect so if there is something i can add it would help.

Dave

[royUK]

You can only add code to do the formats within he macro.

[Dave69rock]

Thanks upgrade needed then.....if i'm lucky i will repost this with at least windows 2003 in the newyear.

Dave