Edit function on macro tool will not highlight/function

B

Bob Ascah

I cannot activate the edit function for a macro. I thought it had something to do with the share workbook function but that didn't help. I have used the file in previous iterations and saved it under different names. Looking back at the past history I have previous versions that do highlight the edit function.
 
G

Gord Dibben

Bob

I assume you can see the macro name in the dialog box?

Is it possible you have protected the VBA Project?

Hit ALT + F11 and select the workbook/project and
right-click>Properties>Protection tab.

Is it locked for viewing?

You will probably need a password if that's the case.

Gord Dibben Excel MVP

On Mon, 19 Jul 2004 17:00:02 -0700, Bob Ascah <Bob
 

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

Top