2 macros to insert new line

D

davegb

I have 2 spreadsheets I use nearly every day. In both, I've written a
macro to insert a new blank line that I fill in, and the new line is
formatted appropriately for that worksheet. I'd like to be able to use
the same shortcut to access each macro. Is there any way to have the
macro in the activesheet run when Cntrl i is pressed, not the macro in
the other worksheet, which is often open at the time. Or do I have to
have different shortcuts in each workbook? Or would one common macro in
my Personal workbook that checks the activesheet name and then inserts
the new line appropriate to that sheet be the easiest way to make this
happen?

Thanks!
 
G

Guest

Put it in your Personal.xls
--
HTH,
Gary Brown
(e-mail address removed)
If this post was helpful to you, please select ''YES'' at the bottom of the
post.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top