ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   macros (https://www.excelbanter.com/excel-programming/332268-macros.html)

Corky

macros
 
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

macros
 
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.


--
HTH
Roger
Shaftesbury (UK)




"Corky" wrote in message
...
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




Corky

macros
 
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

--
Corky


"Roger Whitehead" wrote:

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.


--
HTH
Roger
Shaftesbury (UK)




"Corky" wrote in message
...
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

macros
 
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)





"corky" wrote in message
...
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

--
Corky





Corky

macros
 
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


"Roger Whitehead" wrote:

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)





"corky" wrote in message
...
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

--
Corky







All times are GMT +1. The time now is 02:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com