Search results for query: *

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...

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)

mchughcraig@hotmail.com

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

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.

*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...

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

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 :)

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

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

" 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

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

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...

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...

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...

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?

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...