Personaliser?
 

I'm trying to do homework in Excel and a friend told me I need to find
something called "Personaliser". Does anyone know where this could be found?

Hi
never heard about this in conjunction with Excel. Maybe explain what
your issue is (though for homework just expect to get some hints in the
right direction :-)

--
Regards
Frank Kabel
Frankfurt, Germany

"Mike" schrieb im Newsbeitrag
...
I'm trying to do homework in Excel and a friend told me I need to
find
something called "Personaliser". Does anyone know where this could
be found?

Mike

Maybe Personal.xls which is a workbook that holds your global macros so's they
are available for all open workbooks?

Personal.xls is created the first time you record a Macro using Macro
Recorder.

ToolsMacroRecord New Macro. A dialog box will come up asking you name the
macro and where to place it. Pick Personal Macro Workbook from the dropdown.
Copy and paste a couple of cells then Stop Recording.

You now have a Personal.xls in your Office\XLSTART folder. You can go to
Visual Basic Editor(Alt+F11) to view the macro you just recorded in a Module.

You can add more macros by recording or by typing them into the Module.

You can do a FileSave from there or better yet hit ALT + Q to return to the
Excel window.

Then with Personal.xls active, hit WindowHide.

When you close Excel you will be asked if you want to save Personal.xls. Yes!

It will open hidden next time you start Excel.

Gord Dibben Excel MVP

On Thu, 2 Dec 2004 14:32:28 -0800, "Mike"
wrote:

I'm trying to do homework in Excel and a friend told me I need to find
something called "Personaliser". Does anyone know where this could be found?