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

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

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
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
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,181,301
Messages
5,929,184
Members
436,653
Latest member
Dieguete

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