Button_Click Macro

[ritwikm]

Hi - I am new at macro programming and would like some help at implementing a button inserted through the "forms" toolbar. When I click on the button it should take me to a different worksheeet in the same file (say sheet: 2, row: 2, column: B)?

Thanks
Ritwik

[johnjohns]

This macro will do

Please Login or Register  to view this content.

you can create a button from view->toolbars->forms and assign this macro. Also, for many of the simple tasks, the best way to write macro is recording one. Go to Tools->Macro->Record New Macro. Then perform your task and stop the recording. You can then edit the macro and make the necessary changes, if any.