selkov Posted February 2, 2010 Report Share Posted February 2, 2010 I often fill in repetitive information on numerous different worksheets / webpages etc, Like my name. So I select a line or input box with my mouse and then activate the macro but the macro prints relative to the original position when i captured the macro. How can I get it to execute AT the location I have chosen with the mouse? Quote Link to comment Share on other sites More sharing options...
rberq Posted February 2, 2010 Report Share Posted February 2, 2010 Now that you have captured the macro, open it with the script editor (not the direct editor) and remove whatever mouse commands are positioning you to the wrong place. Once you are familiar with the script editor, you probably won't do much capturing of macros. It's often cleaner just to create a macro from scratch with the editor. For what you are trying to do right now, your whole macro will probably consist of a single line: TEXT TYPE [John Doe] Quote Link to comment Share on other sites More sharing options...
selkov Posted February 3, 2010 Author Report Share Posted February 3, 2010 rberg, thanks. Didi it like you suggested with the editor. Alot easier -Eds Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.