topic Re: copying protected excel workbook in Operating System - Microsoft

copying protected excel workbook

Georg Tresselt — Wed, 24 Jul 2002 10:57:14 GMT

Hi all,

Probably a stupid question: I have a protected (i.e. shared) workbook which I would like to create a copy of for another purpose. But every time I copy it the copy is considered shared and therefore protected. I cannot remove protection via Tools->Protection because I don't know the password.

Does anyone know a workaround?

Thanx alot

Georg

Re: copying protected excel workbook

Frederic Zeller — Wed, 24 Jul 2002 11:55:10 GMT

Hi Georg

If you can open it ( read-only ) you could try :

Either the save as ...

or if it doesn't work, the good old

Select-all , copy

And then paste in a new workbook !

HTH

Fred

Re: copying protected excel workbook

Georg Tresselt — Wed, 24 Jul 2002 12:08:54 GMT

I tried the Save As ... It didn't work. But Copy&Paste does the job.

Re: copying protected excel workbook

Frederic Zeller — Wed, 24 Jul 2002 12:36:57 GMT

Great !

Sometimes we just don't try the most obvious !

Fred