Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macro Warning problems
On Mar 29, 12:45*pm, Eric wrote:
Do you mean the Enable/Disable macros dialog that appears when the workbook opens? If so, just digitally sign the VB project for that workbook using a self-created digital signature (do a Bing or Google search for SELFCERT.EXE). Apply the digital signature to that workbook and then reopen it, making sure you check the box that allows you to "trust" that digital signature. Then you can open the workbook without the macro warning. *By JP "Roy" wrote: Hello group In one PC of mine that have the Office 2003 version the excel had this annoying problem of excel macro notification Security Warning Macros contains viruses.It is usually safe to disable macros,but if the macros are legitimate, you might lose some functionality. then below it are boxes that says Disable Macro , Enable Macros * More Info If I disable Macro it says... The workbook contains a type of Macro( vesion 4 .0) that cannott be disabled. There might be viruses in these Macros. If you are sure this macro is from trusted source click to open the workbook These message kept on recurring whenever I *start Excel on that PC .... Is there a remedy for these pesky notification... and will it not cause problems with the Excel on that pC. TIA Roy .- Hide quoted text - - Show quoted text - Thanks.. looking for self cert exe from google but it seems theinfo I find is for WIN2K option of the office? Is it the same as the office 2003? There are lots of information but so far not one seems to point to my specific problem....? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macro Warning problems
Roy
If every time you start Excel on one particular computer you get the macro warning about "Excel 4.0" macros you do not need SelfCert to sign anything You have some add-in or a stray workbook opening along with Excel. Go to ToolsAdd-ins and uncheck all add-ins. Close and re-start Excel. If no warnings, re-check add-ins one at a time until you find the offender. If you do get the warning, look in your XLSTART folder and remove anything in there. Also remove any path you may have in ToolsOptionsGeneral"At Start up, open all file in" SelfCert is used for signing only those workbooks in which you have deliberately added VBA code. To create a digital certificate if you wanted one go to StartRunProgramsMS OfficeMS OfficeTools Gord Dibben MS Excel MVP On Mon, 29 Mar 2010 13:55:40 -0700 (PDT), Roy wrote: On Mar 29, 12:45*pm, Eric wrote: Do you mean the Enable/Disable macros dialog that appears when the workbook opens? If so, just digitally sign the VB project for that workbook using a self-created digital signature (do a Bing or Google search for SELFCERT.EXE). Apply the digital signature to that workbook and then reopen it, making sure you check the box that allows you to "trust" that digital signature. Then you can open the workbook without the macro warning. *By JP "Roy" wrote: Hello group In one PC of mine that have the Office 2003 version the excel had this annoying problem of excel macro notification Security Warning Macros contains viruses.It is usually safe to disable macros,but if the macros are legitimate, you might lose some functionality. then below it are boxes that says Disable Macro , Enable Macros * More Info If I disable Macro it says... The workbook contains a type of Macro( vesion 4 .0) that cannott be disabled. There might be viruses in these Macros. If you are sure this macro is from trusted source click to open the workbook These message kept on recurring whenever I *start Excel on that PC ... Is there a remedy for these pesky notification... and will it not cause problems with the Excel on that pC. TIA Roy .- Hide quoted text - - Show quoted text - Thanks.. looking for self cert exe from google but it seems theinfo I find is for WIN2K option of the office? Is it the same as the office 2003? There are lots of information but so far not one seems to point to my specific problem....? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macro Warning problems
On 30 Mar, 05:42, Gord Dibben <gorddibbATshawDOTca wrote:
Roy If every time you start Excel on one particular computer you get the macro warning about "Excel 4.0" macros you do not need SelfCert to sign anything You have some add-in or a stray workbook opening along with Excel. Go to ToolsAdd-ins and uncheck all add-ins. Close and re-start Excel. If no warnings, re-check add-ins one at a time until you find the offender. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macro Warning problems
On 30 Mar, 05:42, Gord Dibben <gorddibbATshawDOTca wrote:
If every time you start Excel on one particular computer you get the macro warning about "Excel 4.0" macros you do not need SelfCert to sign anything You have some add-in or a stray workbook opening along with Excel. Go to ToolsAdd-ins and uncheck all add-ins. I looked it there is nothing that was being checked ( that I can uncheck) Close and re-start Excel. If no warnings, re-check add-ins one at a time until you find the offender.. If you do get the warning, look in your XLSTART folder and remove anything In there. I remove one file from XLSTART and it did not change anything. Also remove any path you may have in ToolsOptionsGeneral"At Start up, open all file in" I did not see anything in that slot SelfCert is used for signing only those workbooks in which you have deliberately added VBA code I have not signed or deliberately added VBA code. To create a digital certificate if you wanted one go to StartRunProgramsMS OfficeMS OfficeTools I can’t run these in that PC. I don't understand why that PC is peculiar..is there a way to correct those security warning errors that is becoming pesky everytime I open an excel file in that particular computer? Roy |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macro Warning problems
Does this occur when you open any file in Excel or just one particular file?
If you start Excel with no file open does it occur? StartRun excel.exe Gord On Tue, 30 Mar 2010 23:30:15 -0700 (PDT), Roy wrote: I don't understand why that PC is peculiar..is there a way to correct those security warning errors that is becoming pesky everytime I open an excel file in that particular computer? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macro Warning problems
On Mar 31, 11:23*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Does this occur when you open any file in Excel or just one particular file? If you start Excel with no file open does it occur? StartRun *excel.exe Gord On Tue, 30 Mar 2010 23:30:15 -0700 (PDT), Roy wrote: I don't understand why that PC is *peculiar..is there a way to correct those security warning errors that is becoming pesky everytime I open an excel file in that particular computer?- Hide quoted text - - Show quoted text - Sorry for my late reply as I was not able to use that excel defective pc for some time but only now... I did run the excel exe and the macro warning did not appear , But when I open only that exel file that exhibit that warning.... I would like to know how to remove that warning from that file......as I am at a loss in what to do to sort this pesky problem.. I had tried copying the file and renaming it and the macro warning issue persist.... Hope somebody can help me sort out this problem... Roy |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macro Warning problems
Send me the workbook if you wish.
gorddibbATshawDOTca Change the obvious for my email address. Gord On Sun, 4 Apr 2010 17:32:49 -0700 (PDT), Roy wrote: On Mar 31, 11:23*pm, Gord Dibben <gorddibbATshawDOTca wrote: Does this occur when you open any file in Excel or just one particular file? If you start Excel with no file open does it occur? StartRun *excel.exe Gord On Tue, 30 Mar 2010 23:30:15 -0700 (PDT), Roy wrote: I don't understand why that PC is *peculiar..is there a way to correct those security warning errors that is becoming pesky everytime I open an excel file in that particular computer?- Hide quoted text - - Show quoted text - Sorry for my late reply as I was not able to use that excel defective pc for some time but only now... I did run the excel exe and the macro warning did not appear , But when I open only that exel file that exhibit that warning.... I would like to know how to remove that warning from that file......as I am at a loss in what to do to sort this pesky problem.. I had tried copying the file and renaming it and the macro warning issue persist.... Hope somebody can help me sort out this problem... Roy |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macro Warning problems
On Apr 7, 12:22*am, Gord Dibben <gorddibbATshawDOTca wrote:
Send me the workbook if you wish. gorddibbATshawDOTca Change the obvious for my email address. Gord On Sun, 4 Apr 2010 17:32:49 -0700 (PDT), Roy wrote: On Mar 31, 11:23*pm, Gord Dibben <gorddibbATshawDOTca wrote: Does this occur when you open any file in Excel or just one particular file? If you start Excel with no file open does it occur? StartRun *excel.exe Gord On Tue, 30 Mar 2010 23:30:15 -0700 (PDT), Roy wrote: I don't understand why that PC is *peculiar..is there a way to correct those security warning errors that is becoming pesky everytime I open an excel file in that particular computer?- Hide quoted text - - Show quoted text - Sorry for my late reply as I was not able to use that excel defective pc for some time but only now... I did run the excel exe and the macro warning did not appear , But when I open only that exel file that exhibit that warning.... I would like to know how to remove that warning from that file......as I am at a loss in what to do to sort this pesky problem.. I had tried copying the file and renaming it and the macro warning issue persist.... Hope somebody can help me sort out this problem... Roy- Hide quoted text - - Show quoted text - Hello Gord, thanks for that ! I will send you the offensive file ASAP once I get to that problematic PC. Regards Roy |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macro Warning problems
On Apr 7, 12:22*am, Gord Dibben <gorddibbATshawDOTca wrote:
Send me the workbook if you wish. gorddibbATshawDOTca Change the obvious for my email address. Gord On Sun, 4 Apr 2010 17:32:49 -0700 (PDT), Roy wrote: On Mar 31, 11:23*pm, Gord Dibben <gorddibbATshawDOTca wrote: Does this occur when you open any file in Excel or just one particular file? If you start Excel with no file open does it occur? StartRun *excel.exe Gord On Tue, 30 Mar 2010 23:30:15 -0700 (PDT), Roy wrote: I don't understand why that PC is *peculiar..is there a way to correct those security warning errors that is becoming pesky everytime I open an excel file in that particular computer?- Hide quoted text - - Show quoted text - Sorry for my late reply as I was not able to use that excel defective pc for some time but only now... I did run the excel exe and the macro warning did not appear , But when I open only that exel file that exhibit that warning.... I would like to know how to remove that warning from that file......as I am at a loss in what to do to sort this pesky problem.. I had tried copying the file and renaming it and the macro warning issue persist.... Hope somebody can help me sort out this problem... Roy- Hide quoted text - - Show quoted text - Hello Gord I tried sending the problematic excel workbook to but was rejected many times. I have sent an email check also and was also rejected..... Anyway thanks for your suggestion Roy |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macro Warning problems
Did you change my posted address as I told you?
gorddibbATshawDOTca Change the obvious for my email address. The obvious being the AT and DOT Gord On Wed, 7 Apr 2010 13:35:19 -0700 (PDT), Roy wrote: Hello Gord I tried sending the problematic excel workbook to but was rejected many times. I have sent an email check also and was also rejected..... Anyway thanks for your suggestion Roy |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macro Warning problems
On Apr 8, 6:11*am, Gord Dibben <gorddibbATshawDOTca wrote:
Did you change my posted address as I told you? gorddibbATshawDOTca Change the obvious for my email address. The obvious being the AT and DOT Gord On Wed, 7 Apr 2010 13:35:19 -0700 (PDT), Roy wrote: Hello Gord I tried sending the problematic excel workbook to *but was rejected many times. I have sent an email check also and was also rejected..... Anyway thanks for *your suggestion Roy- Hide quoted text - - Show quoted text - yes I change the AT and DOT with its symbolic counterpart.... |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macro Warning problems
In that case, I'm out of ideas.
Gord On Wed, 7 Apr 2010 21:10:34 -0700 (PDT), Roy wrote: On Apr 8, 6:11*am, Gord Dibben <gorddibbATshawDOTca wrote: Did you change my posted address as I told you? gorddibbATshawDOTca Change the obvious for my email address. The obvious being the AT and DOT Gord On Wed, 7 Apr 2010 13:35:19 -0700 (PDT), Roy wrote: Hello Gord I tried sending the problematic excel workbook to *but was rejected many times. I have sent an email check also and was also rejected..... Anyway thanks for *your suggestion Roy- Hide quoted text - - Show quoted text - yes I change the AT and DOT with its symbolic counterpart.... |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macro Warning problems
On Apr 8, 10:43*pm, Gord Dibben <gorddibbATshawDOTca wrote:
In that case, I'm out of ideas. Gord On Wed, 7 Apr 2010 21:10:34 -0700 (PDT), Roy wrote: On Apr 8, 6:11*am, Gord Dibben <gorddibbATshawDOTca wrote: Did you change my posted address as I told you? gorddibbATshawDOTca Change the obvious for my email address. The obvious being the AT and DOT Gord On Wed, 7 Apr 2010 13:35:19 -0700 (PDT), Roy wrote: Hello Gord I tried sending the problematic excel workbook to *but was rejected many times. I have sent an email check also and was also rejected...... Anyway thanks for *your suggestion Roy- Hide quoted text - - Show quoted text - yes I change the AT and DOT with its symbolic counterpart.... Hi Gord. I send the mail again...and so far it was not rejected anymore....hopes it reaches its destination... Regards Roy |
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macro Warning problems
Nothing as of Friday at 0800 hrs.
Checked my junkmail and not there. Gord On Thu, 8 Apr 2010 20:46:19 -0700 (PDT), Roy wrote: On Apr 8, 10:43*pm, Gord Dibben <gorddibbATshawDOTca wrote: In that case, I'm out of ideas. Gord On Wed, 7 Apr 2010 21:10:34 -0700 (PDT), Roy wrote: On Apr 8, 6:11*am, Gord Dibben <gorddibbATshawDOTca wrote: Did you change my posted address as I told you? gorddibbATshawDOTca Change the obvious for my email address. The obvious being the AT and DOT Gord On Wed, 7 Apr 2010 13:35:19 -0700 (PDT), Roy wrote: Hello Gord I tried sending the problematic excel workbook to *but was rejected many times. I have sent an email check also and was also rejected..... Anyway thanks for *your suggestion Roy- Hide quoted text - - Show quoted text - yes I change the AT and DOT with its symbolic counterpart.... Hi Gord. I send the mail again...and so far it was not rejected anymore....hopes it reaches its destination... Regards Roy |
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macro Warning problems
On Apr 9, 11:04*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Nothing as of Friday at 0800 hrs. Checked my junkmail and not there. Gord On Thu, 8 Apr 2010 20:46:19 -0700 (PDT), Roy wrote: On Apr 8, 10:43*pm, Gord Dibben <gorddibbATshawDOTca wrote: In that case, I'm out of ideas. Gord On Wed, 7 Apr 2010 21:10:34 -0700 (PDT), Roy wrote: On Apr 8, 6:11*am, Gord Dibben <gorddibbATshawDOTca wrote: Did you change my posted address as I told you? gorddibbATshawDOTca Change the obvious for my email address. The obvious being the AT and DOT Gord On Wed, 7 Apr 2010 13:35:19 -0700 (PDT), Roy wrote: Hello Gord I tried sending the problematic excel workbook to *but was rejected many times. I have sent an email check also and was also rejected...... Anyway thanks for *your suggestion Roy- Hide quoted text - - Show quoted text - yes I change the AT and DOT with its symbolic counterpart.... Hi Gord. I *send the mail again...and so far it was not rejected anymore....hopes it reaches *its destination... Regards Roy- Hide quoted text - - Show quoted text - Hello Gord just today I checked my mail and it was rejected again It says: Your message did not reach some or all of the intended recipients. Subject: FW: EXCEL Macro warning problem Sent: 4/9/2010 7:16 AM The following recipient(s) cannot be reached: ' on 4/9/2010 7:17 AM 552 5.7.0 review our attachment guidelines. w30sm947838qce. 10 Roy |
#16
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macro Warning problems
I see single quotes around the address.
How did they get there? Remove them. Others are having no problems with my email. Gord On Fri, 9 Apr 2010 14:02:15 -0700 (PDT), Roy wrote: The following recipient(s) cannot be reached: ' on 4/9/2010 7:17 AM 552 5.7.0 review our attachment guidelines. w30sm947838qce. 10 |
#17
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macro Warning problems
On Apr 10, 7:07*am, Gord Dibben <gorddibbATshawDOTca wrote:
I see single quotes around the address. How did they get there? Remove them. Others are having no problems with my email. Gord On Fri, 9 Apr 2010 14:02:15 -0700 (PDT), Roy wrote: The following recipient(s) cannot be reached: * * ' on 4/9/2010 7:17 AM * * * * * *552 5.7.0 review our attachment guidelines. w30sm947838qce. 10- Hide quoted text - - Show quoted text - Hello Gord Actually there w as no single qoutes in the e mail addie but the report or the rejected mail said so...... I am using microsoft outlook as my mail server.... Regards Roy Anyway I resend it again today already just now.... P.S BTW I sent a tracking email yesterday trying to verify if even without an attachment it will go through.... If you recieve it please let me know... Thanks Roy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro Warning problems | Excel Discussion (Misc queries) | |||
Excel Macro Warning problems | Excel Discussion (Misc queries) | |||
Macro Warning | New Users to Excel | |||
Macro warning box | Excel Discussion (Misc queries) | |||
macro warning | New Users to Excel |