Copy code to a new spreadsheet

M

Markl

I have some code which highlights the active row on a spreadsheet.

I use this quite often and at the moment I copy and paste it from
spreadsheet to spreadsheet.

Is there any way to automate this? e.g. perhaps a customised button on
the toolbar that copies the code to my open spreadsheet

Thanks

Markl
 
P

Paul Lautman

Markl said:
I have some code which highlights the active row on a spreadsheet.

I use this quite often and at the moment I copy and paste it from
spreadsheet to spreadsheet.

Is there any way to automate this? e.g. perhaps a customised button on
the toolbar that copies the code to my open spreadsheet

Thanks

Markl
Click to expand...

Why not just put it into your personal macro workbook, then it is available
to all. Or make it into an addin, then you can distribute it.
 
P

Paul Lautman

Markl said:
Excuse my ignorance but how would I do this?

Thanks
Click to expand...

Easiest way to find your personal macro worksheet is to record a macro and
in the "Store macro in..." box select Personal Macro workbook.

Then when you go into the VBA editor, you PERSONAL.XLS in the project
explorer and you can easily add your stuff to it.

To save as an addin, just go to File->Save As... and Excel addin is the last
one in the "Save as type:" list.

HTH
 
Top