Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 14th 08, 05:04 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,560
Default Automatically deleting macros

I recorded and ran a macro for the the first time and it worked beautifully
but I was suprised that I was not able to fing the macro to run it in a
different workbook. I saved the macro in my Personal Macro Workbook. Do
macros automatically delete or move themselves after they are run? Do I have
to save changes to the workbook the macro was run in for the macro to be
saved? Thanks in advance.
--
Thanks,
David

  #2   Report Post  
Old November 14th 08, 05:13 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 964
Default Automatically deleting macros

If you put the macro in your personal.xls and when you close excel you will
be prompted to save personal.xls
and then you should click yes. If you don't do that the macro will be gone
next time excel opens.
If you haven't closed excel yet the macro should be available but it will
need to be applied from the personal.xls
Press Alt + F8 and you will see the macros you have. Of course if the macro
was specified to run on a particular sheet
in a particular workbook you will get an error if you try to run it for
another workbook or in another sheet

--


Regards,


Peo Sjoblom

"David" wrote in message
...
I recorded and ran a macro for the the first time and it worked beautifully
but I was suprised that I was not able to fing the macro to run it in a
different workbook. I saved the macro in my Personal Macro Workbook. Do
macros automatically delete or move themselves after they are run? Do I
have
to save changes to the workbook the macro was run in for the macro to be
saved? Thanks in advance.
--
Thanks,
David



  #3   Report Post  
Old November 14th 08, 05:56 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,560
Default Automatically deleting macros

Thanks Peo,
Is there a way to save a macro so that it is available in any workbook
and doesn't require being save again after it is run.
--
Thanks,
David


"Peo Sjoblom" wrote:

If you put the macro in your personal.xls and when you close excel you will
be prompted to save personal.xls
and then you should click yes. If you don't do that the macro will be gone
next time excel opens.
If you haven't closed excel yet the macro should be available but it will
need to be applied from the personal.xls
Press Alt + F8 and you will see the macros you have. Of course if the macro
was specified to run on a particular sheet
in a particular workbook you will get an error if you try to run it for
another workbook or in another sheet

--


Regards,


Peo Sjoblom

"David" wrote in message
...
I recorded and ran a macro for the the first time and it worked beautifully
but I was suprised that I was not able to fing the macro to run it in a
different workbook. I saved the macro in my Personal Macro Workbook. Do
macros automatically delete or move themselves after they are run? Do I
have
to save changes to the workbook the macro was run in for the macro to be
saved? Thanks in advance.
--
Thanks,
David




  #4   Report Post  
Old November 14th 08, 06:14 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 964
Default Automatically deleting macros

If you unhide personal.xls under windowunhide and save it there it will
always be available for your other workbooks and this is a one time
operation. After you have saved it do windowshide to hide the personal.xls

If you don't save it using unhide/hide you will be prompted when you exit
excel so another way after you have put a macro in personal.xls would be to
record the macro and close excel and select yes when prompted. The reopen
excel, after that you won't be prompted unless you make changes or add
another macro.

--


Regards,


Peo Sjoblom

"David" wrote in message
...
Thanks Peo,
Is there a way to save a macro so that it is available in any
workbook
and doesn't require being save again after it is run.
--
Thanks,
David


"Peo Sjoblom" wrote:

If you put the macro in your personal.xls and when you close excel you
will
be prompted to save personal.xls
and then you should click yes. If you don't do that the macro will be
gone
next time excel opens.
If you haven't closed excel yet the macro should be available but it will
need to be applied from the personal.xls
Press Alt + F8 and you will see the macros you have. Of course if the
macro
was specified to run on a particular sheet
in a particular workbook you will get an error if you try to run it for
another workbook or in another sheet

--


Regards,


Peo Sjoblom

"David" wrote in message
...
I recorded and ran a macro for the the first time and it worked
beautifully
but I was suprised that I was not able to fing the macro to run it in a
different workbook. I saved the macro in my Personal Macro Workbook.
Do
macros automatically delete or move themselves after they are run? Do
I
have
to save changes to the workbook the macro was run in for the macro to
be
saved? Thanks in advance.
--
Thanks,
David








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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting Macros Larry Ebinger Excel Discussion (Misc queries) 3 December 9th 06 05:05 AM
Deleting Macros Connie Martin Excel Discussion (Misc queries) 2 August 25th 06 05:22 PM
Deleting macros Mindy Excel Worksheet Functions 4 June 23rd 06 07:48 PM
Deleting Macros T Fuller Excel Discussion (Misc queries) 1 January 13th 06 11:03 PM
Deleting Macros Mike Excel Worksheet Functions 2 May 25th 05 04:54 PM


All times are GMT +1. The time now is 07:47 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017