Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mchugh

    converting word to pdf and keeping links

    hi i'm trying to convert a big word document to PDF, but the problem i have, is that its so big, i wish to keep the navigational links that are in place. is this possible? because every time i use distiller, it just seems to make the links into formatted text as opposed to anythink clickable...
  2. mchugh

    unprotecting a worksheet

    hi the problem seems to have been resolved by changing machines - i.e. the installation on the computer i was using seems to be dodgy :\ how frustrating. thanks for all your help Craig (cheers for the .xls geoff)
  3. mchugh

    unprotecting a worksheet

    mchughcraig@hotmail.com
  4. mchugh

    unprotecting a worksheet

    hmmm, i dont suppose anyone could send me a small spreadsheet (doesnt need any data) where it unprotects a password protected sheet in code, and then reprotects it? it would be most appreciated! its just i just removed ALL code from the project, except those key lines, and that still broke :s
  5. mchugh

    unprotecting a worksheet

    i think i'll start a blank work book, and build it again from the bottom up - theres hardly any code anyway, so it wont take that long.
  6. mchugh

    unprotecting a worksheet

    *cries* i cant get this to work at all. when i thought it was working, i think i must have manually unprotected it, and then ran the code - so if theres no protection on the sheet, it runs ok, and it re-protects when its finished successfully too. it just doesnt seem to want to unprotect it at...
  7. mchugh

    unprotecting a worksheet

    hmmm, ok, its stopped working again, but i didnt change anything :s something very odd is going on...
  8. mchugh

    unprotecting a worksheet

    i fixed it! :D its a bit odd though - all i did was move the two activate/select and unprotect lines into another function, and it worked first time! :S i'm not too bothered why to be honest, just glad it works now. thanks for all your suggestions :)
  9. mchugh

    unprotecting a worksheet

    its really frustrating, because it should be a 5 minute job, but its taken me 3 days now, working on one line, which still doesnt work :'( ssVBAdev - the exact error was posted above
  10. mchugh

    unprotecting a worksheet

    well i tried activating the protection in vba, instead of from the menu, and that worked fine - i still get the same error with the unprotect line though :s
  11. mchugh

    unprotecting a worksheet

    " Just to be safe, I would make sure that the password you are using is alpha-numeric and that you only use the password either through code or through the Excel menu but not both." that sounds like a good idea, i'll give that a go
  12. mchugh

    unprotecting a worksheet

    the exact error is... Run-time error '1004': Unprotect method of Worksheet class failed continue (greyed out), end, debug, help
  13. mchugh

    unprotecting a worksheet

    nope, its not shared, i just looked doh, this is annoying :s the password i am using is definately correct, because i can unlock the spreadsheet with it in excel, and its the same password i use for everything on that machine (my dads home computer). i cant think for the life of me what is...
  14. mchugh

    unprotecting a worksheet

    well, password isnt the password, but i know what the password is, and its definately correct in the code. maybe it could be some setting in excel? only the spreadsheet was sent to me with some existing validation etc. and i'm having to work around stuff? maybe theres some other...
  15. mchugh

    unprotecting a worksheet

    ok, its a nasty big function - i could break it down, but its only meant to be a quick fix. this is just in a module Sub findDetails() 'define variables Dim currentPart As String Dim testString As String Dim price As String Dim found As Boolean Dim dateTestString As String 'stops the screen...
  16. mchugh

    unprotecting a worksheet

    hi thanks for the reply i tried it out but i get the same kind of result :s i'm using excel 97 if that makes any difference?
  17. mchugh

    unprotecting a worksheet

    hi i'm currently working on a simple module for a spreadsheet that my father uses at work. the problem i am having is related to protection. certain columns have to be protected, so that people that use the spread sheet cant just input any old values. setting this up is fine. the problem is...

Part and Inventory Search

Back
Top