josephemery
10-30-2005, 02:42 PM
Hello Everybody hopefully someone can give me a idea of what I am doing wrong. I open a word document from Excel and now I want to protect it, so nothing can be changed. I have a couple different things to get it to work. I tried
WordDocumentName.Protect
But for some reason it won?t work I get a debugging error. So I tried to write a Macro in the Word Document so I can run that would protect it. I got the macro to work in the Word Document. So I been trying to call the Word Marco from the Excel Marco to get it to work. I been using
Application.Run ?WordDocumentName.ModuleName.MacroName?
But for some reason neither way is not working.
I was wondering if it something to do with Excel interface with Word. So if anybody got an idea I be gratefully. Thanks
WordDocumentName.Protect
But for some reason it won?t work I get a debugging error. So I tried to write a Macro in the Word Document so I can run that would protect it. I got the macro to work in the Word Document. So I been trying to call the Word Marco from the Excel Marco to get it to work. I been using
Application.Run ?WordDocumentName.ModuleName.MacroName?
But for some reason neither way is not working.
I was wondering if it something to do with Excel interface with Word. So if anybody got an idea I be gratefully. Thanks