View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Macros always available in Personal.xls?

In xl2003 menus, you can show those hidden windows via:

Window|Unhide

If you save personal.xls with the window showing, then it'll be visible the next
time you open it.



Orion Cochrane wrote:

When would PERSONAL be visible? The only way I know to create a PERSONAL.xls
is by recording a macro in it.
--
I am running on Excel 2003, unless otherwise stated.

"Dave Peterson" wrote:

If you call the macros in personal.xls by using alt-f8 (tools|macro|macros),
then the personal.xls has to be open.

Most people store their personal.xls in their XLStart folder so that it opens
each time excel is started. And most people make sure that personal.xls is
hidden so it doesn't get in the way.

scouser wrote:

I've read in numerous posts about saving macros in personal.xls but it
appears personal.xls must be open before other workbooks can 'see' the
macros? Is this true? If not why can't I see the macros? TIA


--

Dave Peterson


--

Dave Peterson