Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I set up a macro to run when a click a moninated cell ?
I want to set up a macro in a worksheet to run when I click a cetain cell in
a worksheet rather than going to tools,macro,macros,clicking on the macro name & run. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I set up a macro to run when a click a moninated cell ?
Sam wrote:
I want to set up a macro in a worksheet to run when I click a cetain cell in a worksheet rather than going to tools,macro,macros,clicking on the macro name & run. Use a button. http://www.mrexcel.com/tip068.shtml What I do for some things that need to be used by others is first have one sheet with the button(s) and the cell(s) that need changing. Have an explanation next to the cells and button and a generic information on the sheet. Next secure the file, so only certain cells can have data. Then selct white as colour, so the grey lines are gone. Put a company logo on there to impress management and it looks as if it is something realy complicated and good. :-D That way people who are not the into the details of what it does behind the scenes still are able to use it easily. houghi -- Please go to : http://tinyurl.com/aqe6y (Google site) and vote for 'Default quoting of previous message in replies' This was a broadcast from the netpolice. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I set up a macro to run when a click a moninated cell ?
Sam, there are a couple of easier ways to do it than picking on a particular
cell to activate the macro. If you just use a cell you have to then add code to some worksheet event such as _SelectionChange or _OnDoubleClick to detect and test which cell got selected/clicked in and then decide which macro to run based on that test. You can use buttons from the Forms icon toolbar (View | Toolbars | Forms) to do the same thing easier - you put the button on a sheet and put appropriate text in it to tell what it does. You can then right-click on it and [Assign macro] and choose an existing macro to be run when you click on it, or you can build a new macro associated with it that will be named something like Button01_Click(). You can even get more creative by using shapes and text boxes from the Drawing toolbar (again: View | Toolbars | Drawing) and you can pretty them up with color and with the TextBox you can do some fancier things with the text in them. You can then right-click and do the Assign Macro thing with them also. You can pretty much [Assign Macro] to anything you can put onto a sheet or form in Excel - even pictures! "Sam" wrote: I want to set up a macro in a worksheet to run when I click a cetain cell in a worksheet rather than going to tools,macro,macros,clicking on the macro name & run. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Click in cell to run macro | Excel Discussion (Misc queries) | |||
Macro: automatically initiating upon cell click | Excel Discussion (Misc queries) | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
Click on cell-calendar drops down-click on date-date fills cell. . | Setting up and Configuration of Excel | |||
Can I launch macro by a cell click ? | Excel Discussion (Misc queries) |