THANKS Gord! EXCEL IS SOOOOOOCOOOOL

"Gord Dibben" wrote:

Stilla

Personal.xls will open when Excel opens.

If you have it set to "hidden" it will open in the background(won't show up on
Window) and your macros will be available for all open workbooks.


Gord Dibben Excel MVP

On Thu, 8 Dec 2005 06:10:06 -0800, Stilla
wrote:

Hi ...THANKS... I beginning to understand the macro logic now. I just opened
the file I was working on yesterday, and my "personal macro file" also opened
in the background.

Is this Excel just being nice, or did I do something wrong?

"wmjenner" wrote:


Yes your logic is correct. Unless you store the macro in the actual
workbook, it doesn't get sent when you e-mail the file to someone so
they cannot open it. Conversely, I have saved macros that hide and
unhide certain worksheets within a workbook (confidential stuff, for
example) in my personal workbook. If you want to give access to
someone to unhide and rehide, you have to then physically copy the
macro to their own personal workbook (or, if they're not down the hall,
send them the code).


--
wmjenner


------------------------------------------------------------------------
wmjenner's Profile: http://www.excelforum.com/member.php...fo&userid=5282
View this thread: http://www.excelforum.com/showthread...hreadid=491639