 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / October 2006Toolbar button for Userform?
I'm trying to create a custom button to call a macro that runs via userform but have been unsuccessful. I can create a button to call the related macro but I need the actual userform to be called. is there a way to do this? Also, is there a way to distribute this button to others that may need it? Or will I have to create it on each computer individually? Thanks in advance for any help! -Ithaca To get the userform to be displayed, you need to have your button run a macro that contains code of the following form: Dim MyDlg As MyUserForm Set MyDlg = New MyUserForm MyDlg.Show Set MyDlg = Nothing Where MyUserForm is the name assigned to your UserForm.  SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > I'm trying to create a custom button to call a macro that runs via > userform [quoted text clipped - 8 lines] > > -Ithaca Thanks a lot Doug! That works perfectly. I want to set up this macro and custom button on multiple users computers here at work so is there an easier way than manually doing so to each computer? > To get the userform to be displayed, you need to have your button run a > macro that contains code of the following form: [quoted text clipped - 5 lines] > > Where MyUserForm is the name assigned to your UserForm. And for distributing the button, macro, and userform (all in the same template) to other users, see http://www.word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm. -- 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. >To get the userform to be displayed, you need to have your button run a >macro that contains code of the following form: [quoted text clipped - 18 lines] >> >> -Ithaca so if I create a new template I can just email it and copy it to the user's Word startup file? and my buttons and everything will be there?? > And for distributing the button, macro, and userform (all in the same > template) to other users, see [quoted text clipped - 29 lines] > >> > >> -Ithaca Right. The hardest part is getting the user to put the file in the correct folder. Since it's marked as a hidden folder, most people need to be shown how to set Windows Explorer to let them see it. -- 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. >so if I create a new template I can just email it and copy it to the user's >Word startup file? and my buttons and everything will be there?? [quoted text clipped - 32 lines] >> >> >> >> -Ithaca Ha! I think I'll be setting it up since it's only like five computers... Eliminate at least some of the error in the process, but there's no way to eliminate my own errors :D Thanks Jay and Doug!!! > Right. The hardest part is getting the user to put the file in the > correct folder. Since it's marked as a hidden folder, most people need [quoted text clipped - 6 lines] > Email cannot be acknowledged; please post all follow-ups to the > newsgroup so all may benefit.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.