I posted text to go with the attachment twice, but either too much or something is goofy. Anyways, here is my shot at it.
@Aflatoon:
Hi there :-) As the OP has been away, I thought I'd wait until he returned, but 'cat-killin' curiousity has gotten the best of me. Did you find your old solution? I too had run into Howard Kaikow's (may he rest in peace) example at http://www.standards.com/Office/SetV...tPassword.html. It must have been some time ago, as I do not recall seeing his sister's notice on the home page.
At least for me, and going off my poor blond memory, I think my prior attempts were trying to run the code in the same instance. For whatever reason, in re-reading Mr. Kaikow's code, it struck me that as he was using VB, Excel was actually seperate, so this time I tried against a seperate instance. Viola! It seems to work. Although probably overly lengthy, and I already spotted a couple of 'not needed' lines, here is what I came up with.
The zip attached contains the primary workbook, three to run against, and a couple of image files. I really got far fancier than needed, as of course only the developer would use this. Anyways, look foreward to seeing what you came up with if you get a chance.
Reply With Quote