Help!!!

trust · Apr 16th, 2002, 08:02 PM

Thank you both so much for your help - I know I'm going to sound totally thick here - but to assign the macro by going macro/record new macro?? How do I get to type in the macro as advised

Sorry - I havn't had alot of experience with macros - as I am sure that you can tell

Thanks for your help

Trust

cornbread · Apr 16th, 2002, 08:46 PM

From the Tools menu select Macro, then record new Macro. It will bring up a pop up screen that will prompt you for a macro name and a hot key ( a key that when you hold down the Ctrl key and hit the key you select as the hot key will run the macro) Once you do that hit "OK" and you do whatever you want recorded then press the stop record button which it provides for you.

cornbread · Apr 16th, 2002, 08:56 PM

Sorry I just read your other post and saw what you are trying to do. Right click on the sheet tab and select "view code" on the left side of the screen you will see a project view of your work book right click in that section and select "insert" then select "Module". You type your macro into that module you just created you can tie your button to it when you are done just like a regular macro that has been recorded.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 16th, 2002, 08:02 PM	#1
trust New Member Join Date: Apr 2002 Posts: 3	Thank you both so much for your help - I know I'm going to sound totally thick here - but to assign the macro by going macro/record new macro?? How do I get to type in the macro as advised Sorry - I havn't had alot of experience with macros - as I am sure that you can tell Thanks for your help Trust

Apr 16th, 2002, 08:46 PM	#2
cornbread Board Regular Join Date: Apr 2002 Location: Oregon Posts: 77	From the Tools menu select Macro, then record new Macro. It will bring up a pop up screen that will prompt you for a macro name and a hot key ( a key that when you hold down the Ctrl key and hit the key you select as the hot key will run the macro) Once you do that hit "OK" and you do whatever you want recorded then press the stop record button which it provides for you.

Apr 16th, 2002, 08:56 PM	#3
cornbread Board Regular Join Date: Apr 2002 Location: Oregon Posts: 77	Sorry I just read your other post and saw what you are trying to do. Right click on the sheet tab and select "view code" on the left side of the screen you will see a project view of your work book right click in that section and select "insert" then select "Module". You type your macro into that module you just created you can tie your button to it when you are done just like a regular macro that has been recorded.