I made a dumb mistake - I password protected a few
worksheets in a workbook so other people could not make
changes and I forgot the password - Now I cannot make
changes. Is there any way of copying these sheets into
another workbook and start from scratch? I attempted to
copy one through Edit Move or Copy Sheet and the Move
or Copy Sheet is grayed out. PLEASE HELP - My boss is
going to stangle me.

Thank you

Try this page of J.E. McGimpsey:

http://www.mcgimpsey.com/excel/removepwords.html
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Karen" wrote in message
...
I made a dumb mistake - I password protected a few
worksheets in a workbook so other people could not make
changes and I forgot the password - Now I cannot make
changes. Is there any way of copying these sheets into
another workbook and start from scratch? I attempted to
copy one through Edit Move or Copy Sheet and the Move
or Copy Sheet is grayed out. PLEASE HELP - My boss is
going to stangle me.

Thank you

Thank you - It worked!
You just saved me a lot of problems!
Live and learn - I won't make that mistake again.
Have a great day!

-----Original Message-----
Try this page of J.E. McGimpsey:

http://www.mcgimpsey.com/excel/removepwords.html
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all
may benefit!
==============================================
"Karen" wrote in
message
...
I made a dumb mistake - I password protected a few
worksheets in a workbook so other people could not make
changes and I forgot the password - Now I cannot make
changes. Is there any way of copying these sheets into
another workbook and start from scratch? I attempted to
copy one through Edit Move or Copy Sheet and the Move
or Copy Sheet is grayed out. PLEASE HELP - My boss is
going to stangle me.

Thank you


.

Well ... I guess that you *CAN* make that same mistake again ... Since you
now know how to overcome it!<g

Thanks for the feed-back.
--
Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"Karen" wrote in message
...
Thank you - It worked!
You just saved me a lot of problems!
Live and learn - I won't make that mistake again.
Have a great day!

-----Original Message-----
Try this page of J.E. McGimpsey:

http://www.mcgimpsey.com/excel/removepwords.html
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all
may benefit!
==============================================
"Karen" wrote in
message
...
I made a dumb mistake - I password protected a few
worksheets in a workbook so other people could not make
changes and I forgot the password - Now I cannot make
changes. Is there any way of copying these sheets into
another workbook and start from scratch? I attempted to
copy one through Edit Move or Copy Sheet and the Move
or Copy Sheet is grayed out. PLEASE HELP - My boss is
going to stangle me.

Thank you


.

Karen

If "move or copy" is grayed out, sounds to me like you also have the workbook
protected under ToolsProtectionProtect Workbook.

If just the sheet was protected, you could still "move or copy" it.

Perhaps two passwords required in this case?

Either way, see RD's post for a link.


Gord Dibben Excel MVP

On Mon, 14 Mar 2005 07:04:50 -0800, "Karen"
wrote:

I made a dumb mistake - I password protected a few
worksheets in a workbook so other people could not make
changes and I forgot the password - Now I cannot make
changes. Is there any way of copying these sheets into
another workbook and start from scratch? I attempted to
copy one through Edit Move or Copy Sheet and the Move
or Copy Sheet is grayed out. PLEASE HELP - My boss is
going to stangle me.

Thank you