D Dave Horne Nov 2, 2007 #1 Hi, I'm trying to create a simple macro but can't get anywhere since the 'create' check box is grayed out. Suggestions? Thanks, DH
Hi, I'm trying to create a simple macro but can't get anywhere since the 'create' check box is grayed out. Suggestions? Thanks, DH
G Guest Nov 3, 2007 #2 I assume you clicked Tools | Macro | New Macro to open the dialog. Does the button remain grayed out after you give the new macro a name? And does ALT+F11 open the VBA editor?
I assume you clicked Tools | Macro | New Macro to open the dialog. Does the button remain grayed out after you give the new macro a name? And does ALT+F11 open the VBA editor?
D Dave Horne Nov 4, 2007 #3 John, now it works fine. Now when I open Macros and give it a Name, the Create box comes to life. That didn't happen before. I don't know why it didn't work before but the 'problem' went away on its own, that plus I manually did the job that I wanted the macro to do anyway. Thanks, Dave Horne
John, now it works fine. Now when I open Macros and give it a Name, the Create box comes to life. That didn't happen before. I don't know why it didn't work before but the 'problem' went away on its own, that plus I manually did the job that I wanted the macro to do anyway. Thanks, Dave Horne
