Cannot edit a Macro

B

Ben C

New Member
Joined
Feb 6, 2006
Messages
31
Hi All,

When I list my macros using alt+F8 the edit option is no longer available, any ideas what I have done?

Many Thanks

Regards

Ben
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Sort by date Sort by votes
Datsmart

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
What macro name is in the "Macro name:" box?
Is the macro that was at the top of the list a valid macro?
Do you have any macros in that workbook?
 
Upvote 0
B

Ben C

New Member
Joined
Feb 6, 2006
Messages
31
Hi, All my macros are listed and they all run ok its just I can't edit them.

Nothing has a password

Thanks for your interest

Regards

Ben
 
Upvote 0
Datsmart

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
What Security Level are you using for Excel?
 
Upvote 0
Datsmart

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
Can you open VBA Editor, (Alt-F11), and edit them there?
 
Upvote 0
B

Ben C

New Member
Joined
Feb 6, 2006
Messages
31
Hi Nate,

I don't know what Step into does - can you advise please?

Many Thanks

Regards

Ben
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question
Chart information reporting add-in?
Replies
2
Views
79
rd18010
R
I
  • Question
Excel hyperlinks not working after moving workbook location.
Replies
1
Views
311
Monty Norman
M
C
  • Question
Edit Macro by Using macro in hundred of sheets
Replies
2
Views
125
My Aswer Is This
My Aswer Is This
O
  • Question
Macros Disabled when sharing file - users don't have the option to Enable
Replies
1
Views
381
Joe4
Joe4
R
  • Question
Error with macros that do not exist
Replies
1
Views
116
johnnyL
J

Forum statistics

Threads
1,191,092
Messages
5,984,593
Members
439,896
Latest member
SquareCare

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top