LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
mahros
 
Posts: n/a
Default How can I copy a protected sheet without copying the protection?

I work in a large organization and I have no idea who protected an excel
sheet that I now have to alter - they may not even be here any more. I have
tried copying the sheet and workbook but it keeps the password even if I copy
it to my hard drive. I understand the need to keep the password on the
original but I want to have my own copy that I can adjust.

Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Autofilter in protected sheet Javier Excel Worksheet Functions 5 March 24th 08 05:56 PM
Macro Errs when sheet is protected Skankles Excel Worksheet Functions 1 February 10th 05 06:44 PM
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. RonMc5 Excel Discussion (Misc queries) 9 February 3rd 05 12:51 AM
Unable to open excel sheet in Protected mode from VB 6.0 ourspt Setting up and Configuration of Excel 0 January 26th 05 11:07 AM
Copy formula...sheet 2 sheet Mick New Users to Excel 0 January 26th 05 01:58 AM


All times are GMT +1. The time now is 11:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"