Personaliser?

M

Mike

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?
 
F

Frank Kabel

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 said:
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
Click to expand...
be found?
 
G

Gord Dibben

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.

Tools>Macro>Record 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 File>Save from there or better yet hit ALT + Q to return to the
Excel window.

Then with Personal.xls active, hit Window>Hide.

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
 
Top