Aerotop Dave Posted June 23, 2005 Share Posted June 23, 2005 I've got a protected sheet with formulas in it. Is there anyway of copying the sheet including the formulas to get round the protection? When I choose Paste and use the drop down menu 'formulas' is greyed out (see pic). Quote Link to comment Share on other sites More sharing options...
Digsy Posted June 23, 2005 Share Posted June 23, 2005 Can't really reproduce your problem here dude. Have you tried a normal Paste Special, or maybe copying the sheet to a new workbook? Quote Link to comment Share on other sites More sharing options...
mikeyb10supra Posted June 23, 2005 Share Posted June 23, 2005 If its protected you cant copy it into another work book......I wrote a macro to get around this but cant remember where I stored it....leave it with me... Quote Link to comment Share on other sites More sharing options...
Aerotop Dave Posted June 23, 2005 Author Share Posted June 23, 2005 Yeah, the formulas didn't copy over. Tell you what, here's the sheet itself, see if anyone can get round the password protection. Edit - bums, can't attach excel sheets Quote Link to comment Share on other sites More sharing options...
mikeyb10supra Posted June 23, 2005 Share Posted June 23, 2005 carefull mate......your risk management at work may throw a fit if you post it...be carefull Quote Link to comment Share on other sites More sharing options...
lust2luv Posted June 23, 2005 Share Posted June 23, 2005 Where? You might have to zip it to be able to attach it to the forum. Quote Link to comment Share on other sites More sharing options...
Aerotop Dave Posted June 23, 2005 Author Share Posted June 23, 2005 carefull mate......your risk management at work may throw a fit if you post it...be carefull *whisper* Well I won't say anything if you don't! Let's see if this works: Quote Link to comment Share on other sites More sharing options...
mikeyb10supra Posted June 23, 2005 Share Posted June 23, 2005 just got script mate no xls file Quote Link to comment Share on other sites More sharing options...
Soonto_HAS_soop Posted June 23, 2005 Share Posted June 23, 2005 Just copy the entire thing into a new document, just worked fine for me. Quote Link to comment Share on other sites More sharing options...
how_supra Posted June 23, 2005 Share Posted June 23, 2005 Yeah just what he said. Copy and dump into a new spreadsheet Quote Link to comment Share on other sites More sharing options...
Jake Posted June 23, 2005 Share Posted June 23, 2005 Just copy the entire thing into a new document, just worked fine for me. Even the hidden columns? Dave, Does this help I've unprotected it. Quote Link to comment Share on other sites More sharing options...
Aerotop Dave Posted June 23, 2005 Author Share Posted June 23, 2005 I couldn't get the formulas to copy over though...? (try looking in D13) Quote Link to comment Share on other sites More sharing options...
Aerotop Dave Posted June 23, 2005 Author Share Posted June 23, 2005 Thanks Jake, that seems to have done the trick. I'll give it a whirl. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.