Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Running Userform
Hia
How can I run a Userform without enabling ActiveX or Macros and without getting into VB Editor? Is there any way to have the list of Userforms (just like the list of Macros)on the main Word interface? Can you help Mates? Nedan Nedzatra |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Running Userform
On Tue, 15 Dec 2009 03:51:01 -0800, Nedan Nedzatra Nedan
wrote: Hia How can I run a Userform without enabling ActiveX or Macros and without getting into VB Editor? Is there any way to have the list of Userforms (just like the list of Macros)on the main Word interface? Can you help Mates? Nedan Nedzatra No. Userforms are absolutely dependent on macros. If macros are disabled, the userform can't run. It sounds like you may have the macro security level set to High, disabling macros. Change it to Medium, and enable macros when you're prompted on opening the document. There is no list of userforms other than in the Project Explorer pane on the VBA editor. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Running Userform
I think I misunderstood your original post.
The proper way to run a userform is to write an ordinary macro in a module (not in ThisDocument or a Class Module) that calls the userform. Greg Maxey's article at http://gregmaxey.mvps.org/Create_and...a_UserForm.htm shows a simple example for displaying a userform named frmSurvey: Sub CallUF() Dim oFrm As frmSurvey Set oFrm = New frmSurvey oFrm.Show Unload oFrm Set oFrm = Nothing End Sub This macro will appear in the Macros dialog, and you can run it from there. Another example is at http://gregmaxey.mvps.org/Address_Le...h_UserForm.htm, for a userform named myFrm, and because that macro is named AutoNew it will run automatically when a new document is created from the template that contains the macro and its userform. Nedan Nedzatra wrote: Hia Thanks for responding Jay. I am able to run User Forms from the VB Editor without enabling Macros and ActiveX. I do it on Word 2007. I place the cursor on the User Form in the VBE and click the Run Sub in the Run Menu or the tringular icon in the ribbon. The codes are placed in Userform Initialize. "Jay Freedman" wrote: On Tue, 15 Dec 2009 03:51:01 -0800, Nedan Nedzatra Nedan wrote: Hia How can I run a Userform without enabling ActiveX or Macros and without getting into VB Editor? Is there any way to have the list of Userforms (just like the list of Macros)on the main Word interface? Can you help Mates? Nedan Nedzatra No. Userforms are absolutely dependent on macros. If macros are disabled, the userform can't run. It sounds like you may have the macro security level set to High, disabling macros. Change it to Medium, and enable macros when you're prompted on opening the document. There is no list of userforms other than in the Project Explorer pane on the VBA editor. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. . |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get a running header with running page numbers? | Page Layout | |||
Userform Template | Microsoft Word Help | |||
Userform | Microsoft Word Help | |||
Userform - .Range_ | Microsoft Word Help | |||
Running Macro from Word vs running macro from vb.net prog | New Users |