Protected Cells in excel

Camalot · 20 Jul 2010 at 12:19

Hey guys.

My work are doing a new rota, they have sent us a template on open office but the cells are all protected.

We need to write the names into the rota but no one knows the password, is there a way around this?

Thanks,
Adam.

Clairvoyant · 20 Jul 2010 at 16:18

Unless you get a password hacker.

mail them and ask for it. Tell them you cant type in any cell to add names.

fretted · 20 Jul 2010 at 23:54

I'm confused. Is the spreadsheet in Excel or Open Office? If it is in Excel, you can use VBA to find out the password

PhillyDee · 21 Jul 2010 at 00:03

You want this:
Codematic wsUnprotector

I have a shareware copy somewhere (nag screens) if you cannot find it.

Pho · 21 Jul 2010 at 00:05

Failing the above if you want to email me (sig) I'll get the password for you, had to do it myself a couple of weeks ago so I could copy some cells (very annoying!).

Camalot · 21 Jul 2010 at 14:43

I've phoned my boss and he doesn't know the password. We have to wait until someone can contact the guy who designed it. It's a pain in the bum!

I'd rather just crack the password and go. All we need to do is start putting names / times into the rota, really don't know why it's locked. Not exactly important stuff

Tysonator · 21 Jul 2010 at 14:46

fretted said:
I'm confused. Is the spreadsheet in Excel or Open Office? If it is in Excel, you can use VBA to find out the password

I use Excel a lot for work, what VBA !
it's not Visual Basic's is it ! !

Bint Box · 21 Jul 2010 at 16:30

Tysonator said:
I use Excel a lot for work, what VBA !
it's not Visual Basic's is it ! !

You cannot use it that much if you have not heard of Visual Basic for Applications.

Rgds
Binty

Bint Box · 21 Jul 2010 at 16:32

Camalot said:
Hey guys.

My work are doing a new rota, they have sent us a template on open office but the cells are all protected.

We need to write the names into the rota but no one knows the password, is there a way around this?

Thanks,
Adam.

Google on how to remove a password from excel, there are lots of ways. An easy one is to use a hex editor to edit the password out.

Rgds
Binty

PhillyDee · 21 Jul 2010 at 16:51

Bint Box said:
You cannot use it that much if you have not heard of Visual Basic for Applications.

Rgds
Binty

I use Excel a lot. Ive never used VBA. Does that mean I am lying? Or just that I only use it as a spreadsheet and calculating values?

Tysonator · 21 Jul 2010 at 17:10

Bint Box said:
You cannot use it that much if you have not heard of Visual Basic for Applications.

Rgds
Binty

Well I use Excel, we have no need to dive in to VBA !
I think I will have to expand my knowledge base !

Bint Box · 21 Jul 2010 at 18:28

PhillyDee said:
I use Excel a lot. Ive never used VBA. Does that mean I am lying? Or just that I only use it as a spreadsheet and calculating values?

I should have rephrased my comment, apologies, I should have said that you used it at a beginners or intermediate level.

Rgds
Binty

fretted · 21 Jul 2010 at 18:40

Hm,

I can post a vba routine that will unlock your worksheet, but am I allowed? You can use Excel help to find out how to run a macro.

me.