Password Protected

[Brian from Maui]

I have a file which is password protected. I thought I could just copy the file as another file name and use it for a template. Can this be done?

 

[Jack in the UK]

Hi Brian

PW the sheet or to open the wkbk??

 

[Brian from Maui]

Jack,

What I would like to do is make changes in the worksheet and use this as a modified template

 

[Jack in the UK]

OK BRian when you select any cell and press any key it pops up protected yes?

If so thats sheet potection.

ok Press CTRL+A and do that together to select all

Paste via CTRL+V in a new sheet but select cell A1 first

This will copy over data and loose formatting and back formatting but data should go

Let me know!!

 

[Brian from Maui]

Aloha Jack

I did copy and paste and it loses some formatting. I just thought there's a way to keep the same formatting etc. and lose the protection by saving as another file name. Thanks anyway Jack!

 

[Jack in the UK]

Hi Brain

Did you protect it?? Forgot the PW??
As your a pal andwonderful friend i offer to try an dBUST it open or recover the password just for you.

PM me what you know and send the sheet if not to large, and ill have my magic try it.

NO promise i can, some will some wont??

Jack

 

[Brian from Maui]

Jack,

That's OK, the worksheet was from our IT department and has macros and is password protected. One of the managers here wanted to use it as a template, but couldn't modify it. Mahalo Jack!

Brian

 

[Jack in the UK]

Brain worth checking your PM

Jack

 

[Jack in the UK]

Brian received and replyed and EMAILS details given

Jack

 

[Jack in the UK]

Hi Brian

Thats far to hard to solve im not that cleaver

[cough]

OK check the PM you have some odd results

OK OK done!!