Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|