Why Is The Macro Edit Button Disabled?

G

Guest

My company has an Excel spreadsheet containing a macro created by an employee
that is no longer with the company. We open the spreadsheet, get prompted
and select to Enable Macros. But when we go to Tools>Macro>Macros, the only
buttons that are enabled for the macro are Run and Cancel. We'd like to edit
this macro. How do we reenable the Edit button?
 
G

Guest

It sounds like the macro in question has been protected by a password. You
don't say which version of Excel you are using but if you open the VBA editor
(Tools>Macro>Visual Basic Editor) and try opening the relevent project,
you'll probably be prompted to enter the password. There are applications
available to help recovery of password protected VBA macros, a quick search
 

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

How to call Excel add-in macro from a button… 1
Auto_Open Macro 5
Macro Hidden - Cannot "Edit" to see code 1
Unable to assign macros to a new button in the current worksheet 1
Where have my macro links gone? 2
Excel 2007: macros disabled on new Vista machine 2
Macros disabled, not by security settings? 5
vba code to enable macros 3

Top