| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Record Macro greyed out
How do I get the macro function to work? The Record Macro, Macro, and Visual
Basic icons are all greyed out, so they do not work. I have reinstalled to insure all features were installed. Under Macro setttings, I selected "Enable all macros". Still nothing. Macros worked fine for me in 2003 version. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Record Macro greyed out
Check the macro security level..
If this post helps click Yes --------------- Jacob Skaria "paullie" wrote: How do I get the macro function to work? The Record Macro, Macro, and Visual Basic icons are all greyed out, so they do not work. I have reinstalled to insure all features were installed. Under Macro setttings, I selected "Enable all macros". Still nothing. Macros worked fine for me in 2003 version. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Record Macro greyed out
Hi,
Check under Office Button, Excel Options, Trust Center, Trust Center Settings, Macro Settings. try Enable all macros... and turn on Trust access to the VBA ... See if this helps. You could also look under Message Bar and make sure Show the Message Bar ... is on. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "paullie" wrote: How do I get the macro function to work? The Record Macro, Macro, and Visual Basic icons are all greyed out, so they do not work. I have reinstalled to insure all features were installed. Under Macro setttings, I selected "Enable all macros". Still nothing. Macros worked fine for me in 2003 version. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Record Macro greyed out
Thanks for the reply. I did already have "Enable all macros" and "Trust
access to VBA" checked. Show Message bar was not checked, but it was greyed out so that it could be checked. "HELP" directions say that the check box will not be available if there are no current messages. "Shane Devenshire" wrote: Hi, Check under Office Button, Excel Options, Trust Center, Trust Center Settings, Macro Settings. try Enable all macros... and turn on Trust access to the VBA ... See if this helps. You could also look under Message Bar and make sure Show the Message Bar ... is on. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "paullie" wrote: How do I get the macro function to work? The Record Macro, Macro, and Visual Basic icons are all greyed out, so they do not work. I have reinstalled to insure all features were installed. Under Macro setttings, I selected "Enable all macros". Still nothing. Macros worked fine for me in 2003 version. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Record Macro greyed out
any resolution?
"paullie" wrote: Thanks for the reply. I did already have "Enable all macros" and "Trust access to VBA" checked. Show Message bar was not checked, but it was greyed out so that it could be checked. "HELP" directions say that the check box will not be available if there are no current messages. "Shane Devenshire" wrote: Hi, Check under Office Button, Excel Options, Trust Center, Trust Center Settings, Macro Settings. try Enable all macros... and turn on Trust access to the VBA ... See if this helps. You could also look under Message Bar and make sure Show the Message Bar ... is on. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "paullie" wrote: How do I get the macro function to work? The Record Macro, Macro, and Visual Basic icons are all greyed out, so they do not work. I have reinstalled to insure all features were installed. Under Macro setttings, I selected "Enable all macros". Still nothing. Macros worked fine for me in 2003 version. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Record Macro and Edit Macro options disabled | New Users to Excel | |||
| Macro screen- everything but Run and cancel is greyed out | Excel Discussion (Misc queries) | |||
| Record New Macro | Setting up and Configuration of Excel | |||
| How do I delete a macro in Excel 2003? Button is greyed out. | Excel Discussion (Misc queries) | |||
| Why is my Macro delete key greyed out? | Excel Discussion (Misc queries) | |||
Linear Mode
