Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro buttons
hello! I have just created a button in my excel spreadsheet, and want to assign a macro to it. I have followed the help in the Excel help menu which suggested that i right click the button and select assign macro. However, when i rightclick the button i created, i don't get this option. i have tried clicking all parts of the button, ie the button itself, and also the selection boxes. Does anyone know of any easier ways of creating buttons and then assigning macros to them, or let me know what i am doing wrong. Thanks ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro buttons
Sheetal, the buttons have to be from the forms toolbar, view, toolbars forms
to right click and assign the macros, sounds like you have a button from the control toolbar -- Paul B Always backup your data before trying something new Using Excel 2000 & 97 Please post any response to the newsgroups so others can benefit from it ** remove news from my email address to reply by email ** "Sheetal" wrote in message ... hello! I have just created a button in my excel spreadsheet, and want to assign a macro to it. I have followed the help in the Excel help menu which suggested that i right click the button and select assign macro. However, when i rightclick the button i created, i don't get this option. i have tried clicking all parts of the button, ie the button itself, and also the selection boxes. Does anyone know of any easier ways of creating buttons and then assigning macros to them, or let me know what i am doing wrong. Thanks ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro buttons
As said before, you only get this message with a button
from the Forms toolbar. However, you should be able to manually assign a macro to a button from the Control Toolbox toolbar. 1)Go into design mode by clicking the icon with the set square and pencil on it, on the Control Toolbox toolbar. 2)Right click on the button and click View Code 3)In the following sub type Call followed by the name of the macro you wish to assign. libby -----Original Message----- hello! I have just created a button in my excel spreadsheet, and want to assign a macro to it. I have followed the help in the Excel help menu which suggested that i right click the button and select assign macro. However, when i rightclick the button i created, i don't get this option. i have tried clicking all parts of the button, ie the button itself, and also the selection boxes. Does anyone know of any easier ways of creating buttons and then assigning macros to them, or let me know what i am doing wrong. Thanks ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro buttons
thanks for the previous problem, i have now rectified it. now, I want to create a macro that can take information from a webpage and copy into my spreadsheet. How can i do this? Everytime this macro is run, the spreadsheet that it will be called into will be the same. Thanks ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro buttons
Sheetal, in the excel sheet you will find... Data ......then Import External Data.....then New Web Query.... there you can select the webpage which you want to copy. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro buttons opening saved macro | Excel Discussion (Misc queries) | |||
Macro Buttons | Excel Worksheet Functions | |||
MACRO BUTTONS | New Users to Excel | |||
Macro Buttons | Excel Discussion (Misc queries) | |||
Macro Buttons | Excel Discussion (Misc queries) |