Menu

2 macros to insert new line

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.programming

Gary Brown Gary Brown is offline

Gary Brown is offline

external usenet poster

Posts: 178

Default

2 macros to insert new line

Put it in your Personal.xls
--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.

"davegb" wrote:

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!

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Insert New Line	Clare	Excel Discussion (Misc queries)	4	July 6th 06 03:40 PM
macros from command line	Cyberwolf	Excel Discussion (Misc queries)	3	July 19th 05 05:35 PM
Insert each line in a new row	BrianB	Excel Discussion (Misc queries)	0	May 31st 05 03:14 PM
Auto Line insert	benosc	Excel Programming	1	March 5th 04 09:14 AM
Automatic line insert	benosc	Excel Programming	1	March 4th 04 05:43 PM

All times are GMT +1. The time now is 07:02 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement