I have xp2003. I am familiar with macros, I use them in more than one
workbook and sheets. I do not get any security level warning dialog. I
can access the macro function anytime I request it. I am not using a
password. You give me the VBA(?) that will perform the function I want.
Now I don't understand exactly what I have to do with it to make it
work. Do I click the record macro button and then type in the info, I'm
just confused.
Thanks
Ken Johnson wrote:
Hi wally,

Are you ofay with macros or a newbie?

What exactly happens?

Is your security level set at medium?

When you open your workbook do you get the Security Warning dialog
which gives you the option of Enabling Macros or Disabling Macros?



To change security level to medium go ToolsMacroSecurity then select
MediumOKClose the workbookreopen the workbook.

If you do get that dialog are you clicking on Enable macros?

Was I correct in assuming you are NOT using a password with your
protection?

It's unlikely to be a version issue, it works on my PCs with XL 2003
and my old iMac with OS 9.2

Let me know how you go. The code works perfectly my end. I'll be using
it myself. Thanks for the idea.

Ken Johnson