-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Cannot edit a Macro
- Thread starter Ben C
- Start date
Datsmart
Well-known Member
- Joined
- Jun 19, 2003
- Messages
- 7,985
When viewing the code in VBA editor, click into the code.
Hit F8. That will put a Yellow hightlight on the first line of code that will be processed when you hit F8 again.
Each time you hit F8 is a "Step" in the code. Size the VBA window so you can view both your code and your worksheet. Excellent way to troubleshoot your code.
Hit F8. That will put a Yellow hightlight on the first line of code that will be processed when you hit F8 again.
Each time you hit F8 is a "Step" in the code. Size the VBA window so you can view both your code and your worksheet. Excellent way to troubleshoot your code.
Upvote
0
Excel Facts
Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Hi,
the Blue title bar says "Microsoft Visual Basic - and the name of the workbook.
If I click the project explorer button I get on the top of the left hand screen a + sign and VBAProject with my file name. If I click the name or the + I get the message "Project Locked" at the top of an error box with "Project is unviewable" below is OK or help. The help leads me to a page on protection and how to change settings. This is workbook is not protected so this is not much help either.
Any ideas?
Thanks
Regards
Ben
the Blue title bar says "Microsoft Visual Basic - and the name of the workbook.
If I click the project explorer button I get on the top of the left hand screen a + sign and VBAProject with my file name. If I click the name or the + I get the message "Project Locked" at the top of an error box with "Project is unviewable" below is OK or help. The help leads me to a page on protection and how to change settings. This is workbook is not protected so this is not much help either.
Any ideas?
Thanks
Regards
Ben
Upvote
0
Refers to the VBA Project not the Workbook
Is this workbook and the associated code in the VBA Project one that you made, or is it one that somebody else made.
If the latter, that person assigned a password to the VBA Project for what ever reason.
Harry
Upvote
0
Hi All,
Nothing is password protected. I have never used any passwords with any excel files. The macros are ones I have written and have been using with this workbook for about 18 months. I have regularly edited them with no problem but the last time I went to change somthing this problem occurred. If I check the Tools protection option it shows nothing as having a password only the option to set one.
Hope this helps
Regards
Ben
Nothing is password protected. I have never used any passwords with any excel files. The macros are ones I have written and have been using with this workbook for about 18 months. I have regularly edited them with no problem but the last time I went to change somthing this problem occurred. If I check the Tools protection option it shows nothing as having a password only the option to set one.
Hope this helps
Regards
Ben
Upvote
0
Datsmart
Well-known Member
- Joined
- Jun 19, 2003
- Messages
- 7,985
Can you edit macros in other workbook files?
Is it just this workbook or all you open?
When you click the plus sign in VBA editor, do you get a prompt asking for a password?
Could someone else have locked your VBA project?
Do you have another saved version of this workbook you can use that allows you to edit your macros?
Is it just this workbook or all you open?
When you click the plus sign in VBA editor, do you get a prompt asking for a password?
Could someone else have locked your VBA project?
Do you have another saved version of this workbook you can use that allows you to edit your macros?
Upvote
0
Hi John,
Please see below
Can you edit macros in other workbook files?
No
Is it just this workbook or all you open?
All
When you click the plus sign in VBA editor, to you get a prompt asking for a password?
No
Could someone else locked your VBA project?
No
Do you have another saved version of this workbook you can use that allows you to edit your macros?
Yes I have another version and yes I can edit in that one. (The macros are all the same)
Thanks
Regards
Ben
Please see below
Can you edit macros in other workbook files?
No
Is it just this workbook or all you open?
All
When you click the plus sign in VBA editor, to you get a prompt asking for a password?
No
Could someone else locked your VBA project?
No
Do you have another saved version of this workbook you can use that allows you to edit your macros?
Yes I have another version and yes I can edit in that one. (The macros are all the same)
Thanks
Regards
Ben
Upvote
0
Similar threads
