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). 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? 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... 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 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 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. 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: 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 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. 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 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. 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) 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now