Personal Macro Workbook

B

Ben

When I try to create a macro via the macro dialog box (Alt
F8) the personal macro workbook in not an option in the
drop down box.

Why is this?

TIA
 
S

Sharad

Hey,

By pressing Alt+F8 you can't record a macro. You can only run existing
macros. So if a macro is not already recroded in Personal.xls, it will
not appear in the dropdwon list.

What you need to do is Click on 'Tools' menu, point to 'Marcros' and
Select 'Record New Macro'. Then in dropdown list you will find 'Personal
Macro Workbook'.
Select it and record your macro.

Sharad
 

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

Unwanted workbooks on startup 2
Personal Macro Workbook 2
Macros 1
Run macro from active workbook whose name keeps changing 20
Save All Worksheets as CSV 7
Setting up a macro that can be ran from any excel file. 1
Save Macro 2
Personal.xls file with multiple Excel versions 7

Top