Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
button 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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
button macro
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 ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dmshurley" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
button macro
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/micro...c19464f875bd25 Gord Dibben MS Excel MVP On Tue, 25 Sep 2007 09:36:00 -0700, dmshurley wrote: 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
button macro
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. "Ron de Bruin" wrote: 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 ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dmshurley" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
button macro
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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dmshurley" wrote in message ... 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. "Ron de Bruin" wrote: 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 ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dmshurley" wrote in message ... 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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
button macro
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? "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dmshurley" wrote in message ... 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. "Ron de Bruin" wrote: 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 ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dmshurley" wrote in message ... 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. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
button macro
Download the example workbooks on my mail page and see a few examples working with a button. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dmshurley" wrote in message ... 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? "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dmshurley" wrote in message ... 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. "Ron de Bruin" wrote: 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 ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dmshurley" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use Macro To Change Which Macro Assigned To Command Button | Excel Discussion (Misc queries) | |||
Creating a macro which presses a button containing a recorded macro | Excel Programming | |||
Can't select macro button after other button is pressed | Excel Programming | |||
Pause macro, add form button to sheet, continue macro when button clicked! | Excel Programming | |||
How to end macro on inital active worksheet containing macro button that was clicked | Excel Programming |