#1   Report Post  
Mike
 
Posts: n/a
Default 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   Report Post  
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 03:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"