macros

[Guest]

Good Morning All

I did not see this message while running windows 98 but since moving up to
xp and combined with inserting more line items I now recieve this error
message:
Macros in this workbook are disabled because security level is high and
macros have not been digitally signed or verified safe. Could someone please
help as the file was of great use and with my lack of knowledge with macros
and programming it now is very frustrating.

Thank you all

 

[Roger Whitehead]

Check your macro security level;

Excel, Tools, Macro, Security.
I suggest you set it to *Medium*. You will then be warned about the
presence of macros each time you open a workbook containing them.

If you are unable to change this setting (assuming you're at work, on a
network), speak with your system administrator.

 

[Guest]

Hi Dave

Thank you for your response. I tried your suggestion but nothing
worked. Do you have any other suggestions? I neglected to inform you but this
file was created by someone else originally!!


Regards,



Corky

 

[Roger Whitehead]

So if you check Tools, Macro, Security now, is it set to Medium? If it has
reverted to High, you need to take advice from your Adminsitrator.

Or, is Security set to Medium, but you get the same error message on opening
the WB?

 

[Guest]

The error message does not appear when you open the file only when you
proceed to click on any of the buttons that take you to a different part of
the file or to another worksheet.
--
Corky

So if you check Tools, Macro, Security now, is it set to Medium? If it has
reverted to High, you need to take advice from your Adminsitrator.

Or, is Security set to Medium, but you get the same error message on opening
the WB?


--
Roger/Dave
Shaftesbury (UK)