I have this spreadsheet with a button at the top that runs a macro (I assume) to add a row to a list of contacts. Since the original macro was created, I have added columns of additional information to the spreadsheet. So now, when I use the button to add a contact it only shifts the first 8 columns of information. I want to edit this to have it include the additional columns. However, when I go to Tools-Macros and select the macro in question, I do not get the option to edit it (grayed out). I've checked the worksheet security and the macro security, to no avail. What else could be keeping me from being able to edit this macro?
lisakmusco_6678
- Status
Joined
·
4,936 Posts
Try pressing ALT + F11 to open the VB editor and then double click the module name on the left hand side to see if the code can be viewed/edited. What version of Excel/Office are you using?
Regards,
Rollin
Regards,
Rollin
Joined
·
4,936 Posts
If he is still unable to view or edit the code it is likely that the VBA project is locked for viewing. If you open the VB editor and click on TOOLS >> VBAProject Properties you may be prompted for the password to access the macro code.
Regards,
Rollin
Regards,
Rollin
- Status
-
?
-
?
-
?
-
?
-
?
-
?
-
?
-
?
-
?
-
?
-
?
-
?
-
?
-
?
-
?
-
?
-
?
-
?
-
?
-
?
