Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Spellcheck macro in FORMS - compile error
I have been trying to get the macro at
http://word.mvps.org/FAQs/MacrosVBA/...ProtectDoc.htm to work, but keep getting a "compile error - can't find project and library", highlighting the part that says 'The following subroutine won't be called if Word 97 is in use If Not Left$(Application.Version, 1) = "8" ?? any ideas? BTW, I am not a prgammer, so I am pretty blind on this one. Cheers |
#2
|
|||
|
|||
AFAIK the macro has been tested in all versions of Word since Word 97. I've
used it in all of those versions without receiving this message. Which version of Word are you using? -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "La La Lara" wrote in message ... I have been trying to get the macro at http://word.mvps.org/FAQs/MacrosVBA/...ProtectDoc.htm to work, but keep getting a "compile error - can't find project and library", highlighting the part that says 'The following subroutine won't be called if Word 97 is in use If Not Left$(Application.Version, 1) = "8" ?? any ideas? BTW, I am not a prgammer, so I am pretty blind on this one. Cheers |
#3
|
|||
|
|||
I am using Word 2000.
"Charles Kenyon" wrote: AFAIK the macro has been tested in all versions of Word since Word 97. I've used it in all of those versions without receiving this message. Which version of Word are you using? -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "La La Lara" wrote in message ... I have been trying to get the macro at http://word.mvps.org/FAQs/MacrosVBA/...ProtectDoc.htm to work, but keep getting a "compile error - can't find project and library", highlighting the part that says 'The following subroutine won't be called if Word 97 is in use If Not Left$(Application.Version, 1) = "8" ?? any ideas? BTW, I am not a prgammer, so I am pretty blind on this one. Cheers |
#4
|
|||
|
|||
Charles, I am using Word 2000.
I am the user who created and owns the form. Interestingly, when I open the form and run the spellcheck macro, it works fine. It's only when other users run the macro that it throws up the compile error. If the user then clicks on "OK", then goes to close the VB window using the X, another pop-up says "This command will stop the debugger". If user then hits "OK" the VB window closes and the user is back in the form, but the form is UNprotected. Any ideas? "Charles Kenyon" wrote: AFAIK the macro has been tested in all versions of Word since Word 97. I've used it in all of those versions without receiving this message. Which version of Word are you using? -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "La La Lara" wrote in message ... I have been trying to get the macro at http://word.mvps.org/FAQs/MacrosVBA/...ProtectDoc.htm to work, but keep getting a "compile error - can't find project and library", highlighting the part that says 'The following subroutine won't be called if Word 97 is in use If Not Left$(Application.Version, 1) = "8" ?? any ideas? BTW, I am not a prgammer, so I am pretty blind on this one. Cheers |
#5
|
|||
|
|||
I am not an author of that macro, only another user. Is everyone (1) using
the same version of Word? (2) using the same macro security settings? (I don't think the macro security settings are the problem because they are getting the compile error; just asking.) In the last two years on these boards I haven't seen errors like those you are describing for this macro. Troubleshooting suggestion: Go to the other user's machines and run the macro yourself, logged in as that user. Do you have the same problems? -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "La La Lara" wrote in message ... Charles, I am using Word 2000. I am the user who created and owns the form. Interestingly, when I open the form and run the spellcheck macro, it works fine. It's only when other users run the macro that it throws up the compile error. If the user then clicks on "OK", then goes to close the VB window using the X, another pop-up says "This command will stop the debugger". If user then hits "OK" the VB window closes and the user is back in the form, but the form is UNprotected. Any ideas? "Charles Kenyon" wrote: AFAIK the macro has been tested in all versions of Word since Word 97. I've used it in all of those versions without receiving this message. Which version of Word are you using? -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "La La Lara" wrote in message ... I have been trying to get the macro at http://word.mvps.org/FAQs/MacrosVBA/...ProtectDoc.htm to work, but keep getting a "compile error - can't find project and library", highlighting the part that says 'The following subroutine won't be called if Word 97 is in use If Not Left$(Application.Version, 1) = "8" ?? any ideas? BTW, I am not a prgammer, so I am pretty blind on this one. Cheers |
#6
|
|||
|
|||
Charles,
Yes, everyone is using the same version of Word. Yes, the same Macro security settings If I go to another user's PC, logged on as them, and run the macro, I get the same compile error. What next??!!! Thanks for your help! "Charles Kenyon" wrote: I am not an author of that macro, only another user. Is everyone (1) using the same version of Word? (2) using the same macro security settings? (I don't think the macro security settings are the problem because they are getting the compile error; just asking.) In the last two years on these boards I haven't seen errors like those you are describing for this macro. Troubleshooting suggestion: Go to the other user's machines and run the macro yourself, logged in as that user. Do you have the same problems? -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "La La Lara" wrote in message ... Charles, I am using Word 2000. I am the user who created and owns the form. Interestingly, when I open the form and run the spellcheck macro, it works fine. It's only when other users run the macro that it throws up the compile error. If the user then clicks on "OK", then goes to close the VB window using the X, another pop-up says "This command will stop the debugger". If user then hits "OK" the VB window closes and the user is back in the form, but the form is UNprotected. Any ideas? "Charles Kenyon" wrote: AFAIK the macro has been tested in all versions of Word since Word 97. I've used it in all of those versions without receiving this message. Which version of Word are you using? -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "La La Lara" wrote in message ... I have been trying to get the macro at http://word.mvps.org/FAQs/MacrosVBA/...ProtectDoc.htm to work, but keep getting a "compile error - can't find project and library", highlighting the part that says 'The following subroutine won't be called if Word 97 is in use If Not Left$(Application.Version, 1) = "8" ?? any ideas? BTW, I am not a prgammer, so I am pretty blind on this one. Cheers |
#7
|
|||
|
|||
I have sorted this now. There was a template attached to the form which
shouldn't have been there. "La La Lara" wrote: Charles, Yes, everyone is using the same version of Word. Yes, the same Macro security settings If I go to another user's PC, logged on as them, and run the macro, I get the same compile error. What next??!!! Thanks for your help! "Charles Kenyon" wrote: I am not an author of that macro, only another user. Is everyone (1) using the same version of Word? (2) using the same macro security settings? (I don't think the macro security settings are the problem because they are getting the compile error; just asking.) In the last two years on these boards I haven't seen errors like those you are describing for this macro. Troubleshooting suggestion: Go to the other user's machines and run the macro yourself, logged in as that user. Do you have the same problems? -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "La La Lara" wrote in message ... Charles, I am using Word 2000. I am the user who created and owns the form. Interestingly, when I open the form and run the spellcheck macro, it works fine. It's only when other users run the macro that it throws up the compile error. If the user then clicks on "OK", then goes to close the VB window using the X, another pop-up says "This command will stop the debugger". If user then hits "OK" the VB window closes and the user is back in the form, but the form is UNprotected. Any ideas? "Charles Kenyon" wrote: AFAIK the macro has been tested in all versions of Word since Word 97. I've used it in all of those versions without receiving this message. Which version of Word are you using? -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "La La Lara" wrote in message ... I have been trying to get the macro at http://word.mvps.org/FAQs/MacrosVBA/...ProtectDoc.htm to work, but keep getting a "compile error - can't find project and library", highlighting the part that says 'The following subroutine won't be called if Word 97 is in use If Not Left$(Application.Version, 1) = "8" ?? any ideas? BTW, I am not a prgammer, so I am pretty blind on this one. Cheers |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Spell Check Macro to work | Microsoft Word Help | |||
How do I fix a MS Visual Basic text box that says "Compile error . | Microsoft Word Help | |||
I keep getting message: Compile error in module: Auto Exec Wha. | Microsoft Word Help | |||
Save As is not working due to macro security settings | Microsoft Word Help |