Cannot edit a Macro

[Ben C]

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

 

[Datsmart]

Wow, don't know what to say.
That is not normal.

I have tested setting different Security settings and cannot duplicate your issue.

Anyone else have any ideas?

 

[pbt]

Sorry I'm late for the party

But you quickly became the life of the party, VoG II

I learned something new today.

Ben,
You must have reasons to make it Shared, don't know why if its only you who have access. But if you follow the link provided by VoG II it's an easy fix. Just tried it myself.

Harry

 

[Ben C]

I have just opened a new worksheet & written a macro there. If I alt & f8 and look at the list of macros I cannot edit the ones from my original shhet but when I scroll down to the new one I have just written then the edit option becomes available.

Ben

 

[Datsmart]

Thanks from me to VoG II too.

Good catch. Thanks for the link.

 

[pbt]

I have just opened a new worksheet & written a macro there.

A new Worksheet or Workbook??

If Workbook, naturally it is not Shared.

The issue of your post was not being able to edit the macros in "a" workbook. Have you tried VoGII 's suggestion on the one you had problems with?

Harry

 

[Ben C]

Hi All,

Just tried the fix from VoGII - all working fine now.

Many Thanks to you all for your help & patience.

Regards

Ben

 

[pbt]

Your welcome

And don't worry, it's those little simple things that just get so annoying and overlooked quite often. We all tend to forget at times.

Harry

 

[VoG]

Blimey! I thought that was a 100:1 shot

Anyway, glad it is fixed and http://support.microsoft.com/search/?adv=1 is always worth a visit for problems like this (and more).