Macros

[Cincy]

I am trying to create some macros in Excel that will be available whenever I open any Excel spreadsheet so I think I need to store the Macro in my Personal Macro Workbook. When I click record macro and select store macro in Personal Macro Workbook it is unable to record the Macro and says "Personal Macro Workbook in the startup folder must stay open for recording". How do I set my computer so the personal macro workbook in the startup folder stays open?

[Marcelo]

create your presonel.xls on other folder and than copy to the startup folder

hth
regards from Brazil
Marcelo

"Cincy" escreveu:

>
> I am trying to create some macros in Excel that will be available
> whenever I open any Excel spreadsheet so I think I need to store the
> Macro in my Personal Macro Workbook. When I click record macro and
> select store macro in Personal Macro Workbook it is unable to record
> the Macro and says "Personal Macro Workbook in the startup folder must
> stay open for recording". How do I set my computer so the personal
> macro workbook in the startup folder stays open?
>
>
> --
> Cincy
> ------------------------------------------------------------------------
> Cincy's Profile: http://www.excelforum.com/member.php...o&userid=35172
> View this thread: http://www.excelforum.com/showthread...hreadid=558586
>
>

[Dave Peterson]

xl2002+ has the abililty to quarantine what it thinks are bad workbooks.

They can keep track of them so that it doesn't even try to open them.

If you look under Help|About MS Excel, you'll see a button called: "Disabled
Items...".

Check under there to see if it's marked not to open. You can enable it there,
too.

If the workbook is really bad, you may want to delete that copy and put a copy
of your backup version into your XLStart folder.

(If you don't have a backup, take the time now and create one.)

Cincy wrote:
>
> I am trying to create some macros in Excel that will be available
> whenever I open any Excel spreadsheet so I think I need to store the
> Macro in my Personal Macro Workbook. When I click record macro and
> select store macro in Personal Macro Workbook it is unable to record
> the Macro and says "Personal Macro Workbook in the startup folder must
> stay open for recording". How do I set my computer so the personal
> macro workbook in the startup folder stays open?
>
> --
> Cincy
> ------------------------------------------------------------------------
> Cincy's Profile: http://www.excelforum.com/member.php...o&userid=35172
> View this thread: http://www.excelforum.com/showthread...hreadid=558586

--

Dave Peterson

[Cincy]

Thanks. I went to the disabled items location you mentioned and enabled the folder. Once I did that the macro buttons and macros automatically appeared in my spreadsheets because I had previously created the macros but couldn't view them because they were disabled.

It did say the personal.xls file was disabled to allow other programs to function so I hope by re-enabling it it doesn't cause me other problems.

I am confused by your statement about creating a backup and that if the workbook is really bad I may want to delete that copy and put a copy into my xlstart folder.

How do I know if the personal.xls file located in my xlstart folder is bad? How do I create a backup?

I also did a search on my computer for the xlstart folder and found that the xlstart folder under program files is empty but I did find the personal.xls file under the Documents and Setting folder for one of the users. Is this the correct location for the personal.xls file?

[Gord Dibben]

Tools>Options>Security.

Set macro security to "medium".

The go to Help>About>Disabled Items

If Personal.xls is disabled, enable it.


Gord Dibben MS Excel MVP

On Wed, 5 Jul 2006 12:56:34 -0500, Cincy
<[email protected]> wrote:

>
>I am trying to create some macros in Excel that will be available
>whenever I open any Excel spreadsheet so I think I need to store the
>Macro in my Personal Macro Workbook. When I click record macro and
>select store macro in Personal Macro Workbook it is unable to record
>the Macro and says "Personal Macro Workbook in the startup folder must
>stay open for recording". How do I set my computer so the personal
>macro workbook in the startup folder stays open?

[Dave Peterson]

If excel disabled the workbook, then it thought something was bad with that
workbook. Deleting the current version and replacing it with a "clean" backup
may clear up the problem.

I just use windows explorer to copy my personal.xls to a new location whenever I
want a backup made. Then if I screw something up, I can use that backup copy.

Cincy wrote:
>
> Thanks. I went to the disabled items location you mentioned and enabled
> the folder. Once I did that the macro buttons and macros automatically
> appeared in my spreadsheets because I had previously created the macros
> but couldn't view them because they were disabled.
>
> It did say the personal.xls file was disabled to allow other programs
> to function so I hope by re-enabling it it doesn't cause me other
> problems.
>
> I am confused by your statement about creating a backup and that if the
> workbook is really bad I may want to delete that copy and put a copy
> into my xlstart folder.
>
> How do I know if the personal.xls file located in my xlstart folder is
> bad? How do I create a backup?
>
> I also did a search on my computer for the xlstart folder and found
> that the xlstart folder under program files is empty but I did find the
> personal.xls file under the Documents and Setting folder for one of the
> users. Is this the correct location for the personal.xls file?
>
> --
> Cincy
> ------------------------------------------------------------------------
> Cincy's Profile: http://www.excelforum.com/member.php...o&userid=35172
> View this thread: http://www.excelforum.com/showthread...hreadid=558586

--

Dave Peterson

[Gord Dibben]

Yes.

Gord Dibben MS Excel MVP

On Wed, 5 Jul 2006 14:13:38 -0500, Cincy
<[email protected]> wrote:

>I also did a search on my computer for the xlstart folder and found
>that the xlstart folder under program files is empty but I did find the
>personal.xls file under the Documents and Setting folder for one of the
>users. Is this the correct location for the personal.xls file?