#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default 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




  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
weird saving of a document with macros resulting with macros being transfered to the copy alfonso gonzales Excel Programming 0 December 12th 04 09:19 PM
Macros inside macros, and pasting into macro code. pagelocator[_2_] Excel Programming 1 November 24th 04 09:11 AM
convert lotus 123w macros to excel macros rpiescik[_2_] Excel Programming 1 September 19th 04 12:41 PM
Macro Size Limit / open macros with macros? andycharger[_7_] Excel Programming 6 February 13th 04 02:00 PM
Macros not appearing in the Tools Macro Macros list hglamy[_2_] Excel Programming 5 October 24th 03 09:10 AM


All times are GMT +1. The time now is 03:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"