Personal Macro Workbook

G

Guest

Had a computer malfunction this morning while working in a spreadsheet & this
afternoon I notice that all my macros have disappeared. Not only that but
when I try to recreate a new one, if I choose to store it in 'Personal Macro
Workbook', I get the following message... 'Personal Macro Workbook in the
startup folder must stay open for recording,' followed by 'Unable to record.'

What on earth is going on??

Thanks in advance for any ideas that you might have.
 
G

Gord Dibben

Montana

Apparently the "malfunction" affected or was caused by the Perosnal.xls.

Go to Help>About Excel and click on "Disabled Items".

Do you see Personal.xls as disabled?

If so, select and enable it.

If it is corrupt, you will have to get rid of it.

Close Excel.

Search for Personal.xls(should be in XLSTART folder).

Dump it and start over with Recording.

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vista problem with NO Personal Macro Workbook in Startup Folder 6
Personal Macro Workbook in startup folder missing 3
Cannot find Personal Macro Workbook 2
MACROS 1
Macros 6
Saving Macro to Personal Workbook 1
Personal Macro Workbook 3
saving macro from workbook to Personal Macro Workbook 1

Top