Is it possible to build a button to add 10 rows ontop wherever row the button located ?

[netanel99]

hello guru's ,

I would like to use this button in 1000's different places in my excel workbook,
would love to know the best code for it,
would be great if that'll be dynamic, so If I'll copy and relocate the button to another place - it still works.

that'll be nice tool for much quicker work.

appreciate the help .

[GC Excel]

Hi,
You could try this code and associate a keyboard shortcut to it instead of a button. Will add 10 rows above current cell.

Please Login or Register  to view this content.

[netanel99]

hey, thanks for helping.
is it 10 rows above my mouse pick'd cell ?

how can I make the shortcut ALT+A ?
I'm new at VBA where do I place the code to make it true for the all workbook ?

[GC Excel]

It will be 10 rows above the selected cell.

For the macro to work in all workbooks, in must be placed in your personnal workbook. See this link that explains how to do it : http://www.rondebruin.nl/win/personal.htm

To assign a keyboard shortcut to you macro : http://office.microsoft.com/en-001/e...005202306.aspx

Hope this helps...

[netanel99]

hi, thanks looks awesome .
I've learned about the personal file, I rather make the code on one sheet(I.E - Template) and then copy paste everytime. pls fix me if I'm wrong - with personal file I guess that I need to do this on every computer that I'll open the file, so I lose being dynamic. and It'll be more ease on system resources if I use it on one sheet and everytime copy paste it, instead of the personal file.

I've done the "by shortcut" macro, it works awesome, but it does something slightly not what I've intented , What the macro does is taking one cell 10 rows down, I'll like to make it so it'll take the all row 10 rows down , sorry for being not precise, I didn't knew this was possible


edited: I see that actually it works on all sheets just after I've added this macro. which is great. I don't think personal file needed .

[GC Excel]

I've done the "by shortcut" macro, it works awesome, but it does something slightly not what I've intented , What the macro does is taking one cell 10 rows down, I'll like to make it so it'll take the all row 10 rows down , sorry for being not precise, I didn't knew this was possible

Not sure to understand what you want.
Can you clarify or post a file with expected result.

[netanel99]

Sure, Appreciate the help .

10RowsDown.xlsx

[GC Excel]

Hi again,
this should work :

Please Login or Register  to view this content.

[netanel99]

works like a charm. brightest solution ever.
Thank you very much.

thought to make 1000's buttons