Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
weird saving of a document with macros resulting with macros being transfered to the copy | Excel Programming | |||
Macros inside macros, and pasting into macro code. | Excel Programming | |||
convert lotus 123w macros to excel macros | Excel Programming | |||
Macro Size Limit / open macros with macros? | Excel Programming | |||
Macros not appearing in the Tools Macro Macros list | Excel Programming |