Macros
 

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

Macros
 

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

Macros
 

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

Macros
 

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

Macros
 

ToolsOptionsSecurity.

Set macro security to "medium".

The go to HelpAboutDisabled Items

If Personal.xls is disabled, enable it.


Gord Dibben MS Excel MVP

On Wed, 5 Jul 2006 12:56:34 -0500, 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?

Macros
 

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

Macros
 

Yes.

Gord Dibben MS Excel MVP

On Wed, 5 Jul 2006 14:13:38 -0500, Cincy
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?