 |
 | 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 / Excel / Programming / September 2007button macro
I want to create a "menu" page that will take you to separate worksheets in a workbook. I can't seem to link the macros to the buttons.... I also want to send a worksheet to an e-mail recipient for approval, and then forward it to another recipient, once approved. I need the code for both the menu and the e-mail and instructions on how to place the macro on the button. Hi dmshurley For mail code see http://www.rondebruin.nl/sendmail.htm Button: Do you want to send one worksheet of the workbook or the whole workbook ?  SignatureRegards Ron de Bruin http://www.rondebruin.nl/tips.htm >I want to create a "menu" page that will take you to separate worksheets in a > workbook. [quoted text clipped - 6 lines] > I need the code for both the menu and the e-mail and instructions on how to > place the macro on the button. I only want to send one worksheet, but I would like to send it to the superintendent for approval using his e-mail address, and then send it to me for processing. Is this possible? Can you help me to understand how to assign macros to buttons, step by step. I'm not a programmer and I have hyperlinks throughout the workbook. I would prefer to use buttons as they look professional. > Hi dmshurley > [quoted text clipped - 13 lines] > > I need the code for both the menu and the e-mail and instructions on how to > > place the macro on the button. There are two option for buttons Forms tool bar Control tool box Right click on a toolbar and check the toolbar you want You can draw a button from the toolbar on your sheet. When it is a forms button you can right click on it and assign a macro to it that is in a standard module of the workbook When it is a control toolbox button go in Edit mode first(first button on this toolbar) Then double click on the button and the VBA edito will open with this Private Sub CommandButton1_Click() End Sub You can add your code between the two lines and close the edit mode. The advantage of this button is that if you copy the sheet to a new workbook you also copy the code in the sheet module to the new workbook. Your button will work in the new workbook. If you use a forms button your code will not work in the new workbook because it point to the old file SignatureRegards Ron de Bruin http://www.rondebruin.nl/tips.htm >I only want to send one worksheet, but I would like to send it to the > superintendent for approval using his e-mail address, and then send it to me [quoted text clipped - 21 lines] >> > I need the code for both the menu and the e-mail and instructions on how to >> > place the macro on the button. You can also assign a macro to any object you insert on a sheet, like a picture of your mother-in-law or your favourite pub<g> Gord Dibben MS Excel MVP >There are two option for buttons > [quoted text clipped - 18 lines] > >If you use a forms button your code will not work in the new workbook because it point to the old file This is good information. Thanks! I'm sure I will have many more questions. In the e-mail code. How do I know which parts of the code to copy to the VBA module to get it to work? > There are two option for buttons > [quoted text clipped - 44 lines] > >> > I need the code for both the menu and the e-mail and instructions on how to > >> > place the macro on the button. Download the example workbooks on my mail page and see a few examples working with a button. SignatureRegards Ron de Bruin http://www.rondebruin.nl/tips.htm > This is good information. Thanks! I'm sure I will have many more questions. > [quoted text clipped - 49 lines] >> >> > I need the code for both the menu and the e-mail and instructions on how to >> >> > place the macro on the button. How about a sheet navigation bar from Dave Peterson? http://www.contextures.on.ca/xlToolbar01.html Or Bob Phillips' Browsesheets macro? See this google search result. All one line for the URL http://groups.google.com/group/microsoft.public.excel.worksheet.functions/browse _frm/thread/935f5e174087f636/02c19464f875bd25?lnk=st&q=&rnum=1#02c19464f875bd25 Gord Dibben MS Excel MVP >I want to create a "menu" page that will take you to separate worksheets in a >workbook. [quoted text clipped - 6 lines] >I need the code for both the menu and the e-mail and instructions on how to >place the macro on the button. |
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.