Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Asigning code to Button with Macro
I have a macro that create a button. I want to add code to control that
button with the same macro that creates the button. Each time the macro creates a button, it adds a module where it puts the text (code). Sub ButtonName_Click() End Sub I would like to add code between the lines as follows Application.ScreenUpdating = False Sheets("MSBs").Visible = True ActiveWindow.SelectedSheets.Visible = False Application.ScreenUpdating = True So when the button is pressed this code runs. I have worked at it for days now without asking for help but I can't figure it out. Any suggestions? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro code behind button | Excel Worksheet Functions | |||
Asigning a value to words | Excel Discussion (Misc queries) | |||
Code created in a Macro not working for a Command Button | Excel Programming | |||
Attaching a macro (module) code to button | Excel Programming | |||
how to add code programmatically to a macro for a button | Excel Programming |