common macros ready to use in every instance

[leecavturbo]

i have a couple of macro's i use regular.
can these be loaded when i open excel so they are there to run on any workbook i open?

 

[RoryA]

Yes - you need to move them to you Personal Macro Workbook if you have one. If you don't already have one, just start recording a macro and choose to save it in the Personal Macro Workbook - this will create the workbook for you. (You don't avtually have to do anything with the macro - just start then stop recording).

 

[leecavturbo]

ok thanks. i have absolutely no idea on how to record a macro or understand the code at all. basically you kind fellows have given me the codes (text) i need on here then somehow i have bludgened my way to find how to apply that code in a macro and run it. so i could do with some brief guidance from: once i have the code (text) now what?

 

[SydneyGeek]

Another option is to create an Add-In containing the code. Takes a bit more work but it has advantages; others can use the macros too, difficult if they are in your Personal Macro Workbook.

Just saw your reply -- if you are only getting started, go for the Personal Macro Workbook.
Denis

 

[RoryA]

Which version of Excel are you using?

 

[leecavturbo]

2002

 

[RoryA]

Then it's:
Tools->Macro->Record new macro... and from the dropdown choose to store it in the Personal Macro Workbook. You should then see the Recording toolbar appear - just press the Stop button and you shoul dnow have a Personal Macro workbook (called Personal.xls) visible in the VBEditor. You can copy and paste your code into a new module in that workbook. The Personal Macro Workbook is automatically started up whenever you start Excel.

 

[SydneyGeek]

Personal Macro Workbook is a hidden workbook that opens every time you launch Excel.

1. Record a macro to do anything (eg, switch worksheets). You get the option of where to store it; choose Personal Macro Workbook. Once you have finishd the macro, stop the recorder

2. Windows > Unhide, and select Personal Macro Workbook

3. Alt+F8, select the macro name that you just recorded, click Edit

4. Copy the macros you actually want to use, and paste them over the junk one that you recorded. Save, and Alt+Q to return to Excel

5. Make sure you are in Personal Macro Workbook, and Windows > Hide.

6. Now you can run the macros by using Alt+F8 to bring up the dialog, and double-clicking the macro name. If you like you can also attach the macros to buttons.

Denis

 

[leecavturbo]

the recording tool bar does not appear after selecting personal!
?

 

[leecavturbo]

this macro was working now i get run time error 13?
. only thing that might be different in the sheet it worked on and the sheet it now doesn't is the none working sheet might have more than 1 empty cells in a column together