how to edit a macro

[Daniel]

I created a macro and now want to edit.
When I click the name the 'edit' is now highlight or dim, not function
I changed the security level to low and not help
Need your help
THanks
Daniel

 

[Gord Dibben]

Daniel

Is the workbook shared under Tools>Share Workbook?

Is the VBAProject locked for viewing?

Hit Alt + F11 to go to VBE and double-click on your workbook/project.

Any message or does the module open for editing?


Gord Dibben MS Excel MVP

 

[Daniel]

Thanks Gord Dibben

The worksheet was protected and I forgot that
Daniel

 

[Gord Dibben]

Sheet or workbook protection should not prevent you from editing macros.


Gord