Password Protected

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,459
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?
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,459
Jack,

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

Jack in the UK

Well-known Member
Joined
Feb 16, 2002
Messages
3,215
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

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,459

ADVERTISEMENT

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! :biggrin:
 

Jack in the UK

Well-known Member
Joined
Feb 16, 2002
Messages
3,215
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

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,459

ADVERTISEMENT

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

Well-known Member
Joined
Feb 16, 2002
Messages
3,215
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!!
 

Forum statistics

Threads
1,147,816
Messages
5,743,376
Members
423,790
Latest member
kevinlee_5

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top