| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro warning when no macros in workbook
I have a user who has several Excel workbooks that give the macro warning
when opened, even though there are no macros in the workbooks. His security is set to high, and I can arrange to lower the setting if it is required, but would prefer to leave it set at the companies default setting (high). Does anyone have any idea why a workbook with no macros would trigger the warning Thanxz |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro warning when no macros in workbook
Bill, You also have to remove the modules on which the macros were stored
have a look here for details http://www.contextures.com/xlfaqMac.html#NoMacros -- Paul B Always backup your data before trying something new Using Excel 97 & 2000 Please post any response to the newsgroups so others can benefit from it ** remove news from my email address to reply by email ** "BillS" wrote in message . .. I have a user who has several Excel workbooks that give the macro warning when opened, even though there are no macros in the workbooks. His security is set to high, and I can arrange to lower the setting if it is required, but would prefer to leave it set at the companies default setting (high). Does anyone have any idea why a workbook with no macros would trigger the warning Thanxz |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro warning when no macros in workbook
You need to delete any empty modules that housed those macros.
Hit ALT+F11 and this will open the VBE (Visual Basic Editor) Top left you will hopefully see an explorer style pane. Within this pane you need to search for your workbook's name, and when you find it you may need to click on the + to expand it. Within that you should see the following:- VBAProject(Your_Filename) Microsoft Excel Objects Sheet1(Sheet1) Sheet2(Sheet2) Sheet3(Sheet3) ThisWorkbook Modules Module1 Module2 etc etc (You may have just 1 of these) If you have named your sheets then those names will appear in the brackets above as opposed to what you see at the moment in my note. Right click on the modules and select remove. When prompted with a question re exporting, just hit no. Then hit File / Close and return to Microsoft Excel and save the file. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP ---------------------------------------------------------------------------- Attitude - A little thing that makes a BIG difference ---------------------------------------------------------------------------- "BillS" wrote in message . .. I have a user who has several Excel workbooks that give the macro warning when opened, even though there are no macros in the workbooks. His security is set to high, and I can arrange to lower the setting if it is required, but would prefer to leave it set at the companies default setting (high). Does anyone have any idea why a workbook with no macros would trigger the warning Thanxz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro warning when no macros in workbook
Ken:
I did as you suggested, but "Modules" does not appear under the workbook name, Just "Excel Objects". Any other suggestions? Would this change if he e-mailed me the files, rather than me looking at them on his system? BillS "Ken Wright" wrote in message ... You need to delete any empty modules that housed those macros. Hit ALT+F11 and this will open the VBE (Visual Basic Editor) Top left you will hopefully see an explorer style pane. Within this pane you need to search for your workbook's name, and when you find it you may need to click on the + to expand it. Within that you should see the following:- VBAProject(Your_Filename) Microsoft Excel Objects Sheet1(Sheet1) Sheet2(Sheet2) Sheet3(Sheet3) ThisWorkbook Modules Module1 Module2 etc etc (You may have just 1 of these) If you have named your sheets then those names will appear in the brackets above as opposed to what you see at the moment in my note. Right click on the modules and select remove. When prompted with a question re exporting, just hit no. Then hit File / Close and return to Microsoft Excel and save the file. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message . .. I have a user who has several Excel workbooks that give the macro warning when opened, even though there are no macros in the workbooks. His security is set to high, and I can arrange to lower the setting if it is required, but would prefer to leave it set at the companies default setting (high). Does anyone have any idea why a workbook with no macros would trigger the warning Thanxz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro warning when no macros in workbook
Doubleclick on the ThisWorkbook object and see if there is any code in there - If so then
delete the code and save the workbook. Him emailing you the file shouldn't make any difference - The macro or module would have to be in the file that was being opened at the time to generate the warning message -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP ---------------------------------------------------------------------------- Attitude - A little thing that makes a BIG difference ---------------------------------------------------------------------------- "BillS" wrote in message .. . Ken: I did as you suggested, but "Modules" does not appear under the workbook name, Just "Excel Objects". Any other suggestions? Would this change if he e-mailed me the files, rather than me looking at them on his system? BillS "Ken Wright" wrote in message ... You need to delete any empty modules that housed those macros. Hit ALT+F11 and this will open the VBE (Visual Basic Editor) Top left you will hopefully see an explorer style pane. Within this pane you need to search for your workbook's name, and when you find it you may need to click on the + to expand it. Within that you should see the following:- VBAProject(Your_Filename) Microsoft Excel Objects Sheet1(Sheet1) Sheet2(Sheet2) Sheet3(Sheet3) ThisWorkbook Modules Module1 Module2 etc etc (You may have just 1 of these) If you have named your sheets then those names will appear in the brackets above as opposed to what you see at the moment in my note. Right click on the modules and select remove. When prompted with a question re exporting, just hit no. Then hit File / Close and return to Microsoft Excel and save the file. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message . .. I have a user who has several Excel workbooks that give the macro warning when opened, even though there are no macros in the workbooks. His security is set to high, and I can arrange to lower the setting if it is required, but would prefer to leave it set at the companies default setting (high). Does anyone have any idea why a workbook with no macros would trigger the warning Thanxz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro warning when no macros in workbook
Nope, nothing.
Confused yet?(like me?) "Ken Wright" wrote in message ... Doubleclick on the ThisWorkbook object and see if there is any code in there - If so then delete the code and save the workbook. Him emailing you the file shouldn't make any difference - The macro or module would have to be in the file that was being opened at the time to generate the warning message -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message .. . Ken: I did as you suggested, but "Modules" does not appear under the workbook name, Just "Excel Objects". Any other suggestions? Would this change if he e-mailed me the files, rather than me looking at them on his system? BillS "Ken Wright" wrote in message ... You need to delete any empty modules that housed those macros. Hit ALT+F11 and this will open the VBE (Visual Basic Editor) Top left you will hopefully see an explorer style pane. Within this pane you need to search for your workbook's name, and when you find it you may need to click on the + to expand it. Within that you should see the following:- VBAProject(Your_Filename) Microsoft Excel Objects Sheet1(Sheet1) Sheet2(Sheet2) Sheet3(Sheet3) ThisWorkbook Modules Module1 Module2 etc etc (You may have just 1 of these) If you have named your sheets then those names will appear in the brackets above as opposed to what you see at the moment in my note. Right click on the modules and select remove. When prompted with a question re exporting, just hit no. Then hit File / Close and return to Microsoft Excel and save the file. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message . .. I have a user who has several Excel workbooks that give the macro warning when opened, even though there are no macros in the workbooks. His security is set to high, and I can arrange to lower the setting if it is required, but would prefer to leave it set at the companies default setting (high). Does anyone have any idea why a workbook with no macros would trigger the warning Thanxz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro warning when no macros in workbook
When you open the file, do you get prompted with the warning message??
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP ---------------------------------------------------------------------------- Attitude - A little thing that makes a BIG difference ---------------------------------------------------------------------------- "BillS" wrote in message . .. Nope, nothing. Confused yet?(like me?) "Ken Wright" wrote in message ... Doubleclick on the ThisWorkbook object and see if there is any code in there - If so then delete the code and save the workbook. Him emailing you the file shouldn't make any difference - The macro or module would have to be in the file that was being opened at the time to generate the warning message -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message .. . Ken: I did as you suggested, but "Modules" does not appear under the workbook name, Just "Excel Objects". Any other suggestions? Would this change if he e-mailed me the files, rather than me looking at them on his system? BillS "Ken Wright" wrote in message ... You need to delete any empty modules that housed those macros. Hit ALT+F11 and this will open the VBE (Visual Basic Editor) Top left you will hopefully see an explorer style pane. Within this pane you need to search for your workbook's name, and when you find it you may need to click on the + to expand it. Within that you should see the following:- VBAProject(Your_Filename) Microsoft Excel Objects Sheet1(Sheet1) Sheet2(Sheet2) Sheet3(Sheet3) ThisWorkbook Modules Module1 Module2 etc etc (You may have just 1 of these) If you have named your sheets then those names will appear in the brackets above as opposed to what you see at the moment in my note. Right click on the modules and select remove. When prompted with a question re exporting, just hit no. Then hit File / Close and return to Microsoft Excel and save the file. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message . .. I have a user who has several Excel workbooks that give the macro warning when opened, even though there are no macros in the workbooks. His security is set to high, and I can arrange to lower the setting if it is required, but would prefer to leave it set at the companies default setting (high). Does anyone have any idea why a workbook with no macros would trigger the warning Thanxz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro warning when no macros in workbook
Also try doubleclicking the sheet modules themselves to see if you have any event macros
in there - Again just delete them if you do (Once you know what they were doing of course). -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP ---------------------------------------------------------------------------- Attitude - A little thing that makes a BIG difference ---------------------------------------------------------------------------- "BillS" wrote in message . .. Nope, nothing. Confused yet?(like me?) "Ken Wright" wrote in message ... Doubleclick on the ThisWorkbook object and see if there is any code in there - If so then delete the code and save the workbook. Him emailing you the file shouldn't make any difference - The macro or module would have to be in the file that was being opened at the time to generate the warning message -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message .. . Ken: I did as you suggested, but "Modules" does not appear under the workbook name, Just "Excel Objects". Any other suggestions? Would this change if he e-mailed me the files, rather than me looking at them on his system? BillS "Ken Wright" wrote in message ... You need to delete any empty modules that housed those macros. Hit ALT+F11 and this will open the VBE (Visual Basic Editor) Top left you will hopefully see an explorer style pane. Within this pane you need to search for your workbook's name, and when you find it you may need to click on the + to expand it. Within that you should see the following:- VBAProject(Your_Filename) Microsoft Excel Objects Sheet1(Sheet1) Sheet2(Sheet2) Sheet3(Sheet3) ThisWorkbook Modules Module1 Module2 etc etc (You may have just 1 of these) If you have named your sheets then those names will appear in the brackets above as opposed to what you see at the moment in my note. Right click on the modules and select remove. When prompted with a question re exporting, just hit no. Then hit File / Close and return to Microsoft Excel and save the file. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message . .. I have a user who has several Excel workbooks that give the macro warning when opened, even though there are no macros in the workbooks. His security is set to high, and I can arrange to lower the setting if it is required, but would prefer to leave it set at the companies default setting (high). Does anyone have any idea why a workbook with no macros would trigger the warning Thanxz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro warning when no macros in workbook
Yep, on file open, on a system with security set to high.
"Ken Wright" wrote in message ... When you open the file, do you get prompted with the warning message?? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message . .. Nope, nothing. Confused yet?(like me?) "Ken Wright" wrote in message ... Doubleclick on the ThisWorkbook object and see if there is any code in there - If so then delete the code and save the workbook. Him emailing you the file shouldn't make any difference - The macro or module would have to be in the file that was being opened at the time to generate the warning message -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message .. . Ken: I did as you suggested, but "Modules" does not appear under the workbook name, Just "Excel Objects". Any other suggestions? Would this change if he e-mailed me the files, rather than me looking at them on his system? BillS "Ken Wright" wrote in message ... You need to delete any empty modules that housed those macros. Hit ALT+F11 and this will open the VBE (Visual Basic Editor) Top left you will hopefully see an explorer style pane. Within this pane you need to search for your workbook's name, and when you find it you may need to click on the + to expand it. Within that you should see the following:- VBAProject(Your_Filename) Microsoft Excel Objects Sheet1(Sheet1) Sheet2(Sheet2) Sheet3(Sheet3) ThisWorkbook Modules Module1 Module2 etc etc (You may have just 1 of these) If you have named your sheets then those names will appear in the brackets above as opposed to what you see at the moment in my note. Right click on the modules and select remove. When prompted with a question re exporting, just hit no. Then hit File / Close and return to Microsoft Excel and save the file. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message . .. I have a user who has several Excel workbooks that give the macro warning when opened, even though there are no macros in the workbooks. His security is set to high, and I can arrange to lower the setting if it is required, but would prefer to leave it set at the companies default setting (high). Does anyone have any idea why a workbook with no macros would trigger the warning Thanxz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro warning when no macros in workbook
OK, if you've hit the point where you are fed up, then by all means mail it on down if you
can, and I'll happily take a look. You'd need to take the NOSPAM bit out of email address though. - Just checking though, you did see my last note where I said to try doubleclicking the sheet modules to look for any event macros? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP ---------------------------------------------------------------------------- Attitude - A little thing that makes a BIG difference ---------------------------------------------------------------------------- "BillS" wrote in message . .. Yep, on file open, on a system with security set to high. "Ken Wright" wrote in message ... When you open the file, do you get prompted with the warning message?? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message . .. Nope, nothing. Confused yet?(like me?) "Ken Wright" wrote in message ... Doubleclick on the ThisWorkbook object and see if there is any code in there - If so then delete the code and save the workbook. Him emailing you the file shouldn't make any difference - The macro or module would have to be in the file that was being opened at the time to generate the warning message -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message .. . Ken: I did as you suggested, but "Modules" does not appear under the workbook name, Just "Excel Objects". Any other suggestions? Would this change if he e-mailed me the files, rather than me looking at them on his system? BillS "Ken Wright" wrote in message ... You need to delete any empty modules that housed those macros. Hit ALT+F11 and this will open the VBE (Visual Basic Editor) Top left you will hopefully see an explorer style pane. Within this pane you need to search for your workbook's name, and when you find it you may need to click on the + to expand it. Within that you should see the following:- VBAProject(Your_Filename) Microsoft Excel Objects Sheet1(Sheet1) Sheet2(Sheet2) Sheet3(Sheet3) ThisWorkbook Modules Module1 Module2 etc etc (You may have just 1 of these) If you have named your sheets then those names will appear in the brackets above as opposed to what you see at the moment in my note. Right click on the modules and select remove. When prompted with a question re exporting, just hit no. Then hit File / Close and return to Microsoft Excel and save the file. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message . .. I have a user who has several Excel workbooks that give the macro warning when opened, even though there are no macros in the workbooks. His security is set to high, and I can arrange to lower the setting if it is required, but would prefer to leave it set at the companies default setting (high). Does anyone have any idea why a workbook with no macros would trigger the warning Thanxz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro warning when no macros in workbook
Yep, tried that too, I think I'll just let him keep answering the security
warning, he tends to be annoying anyhow, so... (Yep, I'm a professional. no really....) "Ken Wright" wrote in message ... OK, if you've hit the point where you are fed up, then by all means mail it on down if you can, and I'll happily take a look. You'd need to take the NOSPAM bit out of email address though. - Just checking though, you did see my last note where I said to try doubleclicking the sheet modules to look for any event macros? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message . .. Yep, on file open, on a system with security set to high. "Ken Wright" wrote in message ... When you open the file, do you get prompted with the warning message?? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message . .. Nope, nothing. Confused yet?(like me?) "Ken Wright" wrote in message ... Doubleclick on the ThisWorkbook object and see if there is any code in there - If so then delete the code and save the workbook. Him emailing you the file shouldn't make any difference - The macro or module would have to be in the file that was being opened at the time to generate the warning message -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message .. . Ken: I did as you suggested, but "Modules" does not appear under the workbook name, Just "Excel Objects". Any other suggestions? Would this change if he e-mailed me the files, rather than me looking at them on his system? BillS "Ken Wright" wrote in message ... You need to delete any empty modules that housed those macros. Hit ALT+F11 and this will open the VBE (Visual Basic Editor) Top left you will hopefully see an explorer style pane. Within this pane you need to search for your workbook's name, and when you find it you may need to click on the + to expand it. Within that you should see the following:- VBAProject(Your_Filename) Microsoft Excel Objects Sheet1(Sheet1) Sheet2(Sheet2) Sheet3(Sheet3) ThisWorkbook Modules Module1 Module2 etc etc (You may have just 1 of these) If you have named your sheets then those names will appear in the brackets above as opposed to what you see at the moment in my note. Right click on the modules and select remove. When prompted with a question re exporting, just hit no. Then hit File / Close and return to Microsoft Excel and save the file. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message . .. I have a user who has several Excel workbooks that give the macro warning when opened, even though there are no macros in the workbooks. His security is set to high, and I can arrange to lower the setting if it is required, but would prefer to leave it set at the companies default setting (high). Does anyone have any idea why a workbook with no macros would trigger the warning Thanxz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro warning when no macros in workbook
OK - Your call, but I'm quite happy to take a look at it for you if you want, so the
offer's there. You could even delete the data out and send it. In fact, that might be a way to narrow it down. With a copy of the book - Insert a new sheet and then delete all the others. save the book and reopen - If no macro warning, then recopy the original and delete all sheets but the first - save and reopen, and just try and home in on what sheet if any is causing the problem. Maybe you have some controls with macros in somewhere - who knows. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP ---------------------------------------------------------------------------- Attitude - A little thing that makes a BIG difference ---------------------------------------------------------------------------- "BillS" wrote in message . .. Yep, tried that too, I think I'll just let him keep answering the security warning, he tends to be annoying anyhow, so... (Yep, I'm a professional. no really....) "Ken Wright" wrote in message ... OK, if you've hit the point where you are fed up, then by all means mail it on down if you can, and I'll happily take a look. You'd need to take the NOSPAM bit out of email address though. - Just checking though, you did see my last note where I said to try doubleclicking the sheet modules to look for any event macros? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message . .. Yep, on file open, on a system with security set to high. "Ken Wright" wrote in message ... When you open the file, do you get prompted with the warning message?? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message . .. Nope, nothing. Confused yet?(like me?) "Ken Wright" wrote in message ... Doubleclick on the ThisWorkbook object and see if there is any code in there - If so then delete the code and save the workbook. Him emailing you the file shouldn't make any difference - The macro or module would have to be in the file that was being opened at the time to generate the warning message -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message .. . Ken: I did as you suggested, but "Modules" does not appear under the workbook name, Just "Excel Objects". Any other suggestions? Would this change if he e-mailed me the files, rather than me looking at them on his system? BillS "Ken Wright" wrote in message ... You need to delete any empty modules that housed those macros. Hit ALT+F11 and this will open the VBE (Visual Basic Editor) Top left you will hopefully see an explorer style pane. Within this pane you need to search for your workbook's name, and when you find it you may need to click on the + to expand it. Within that you should see the following:- VBAProject(Your_Filename) Microsoft Excel Objects Sheet1(Sheet1) Sheet2(Sheet2) Sheet3(Sheet3) ThisWorkbook Modules Module1 Module2 etc etc (You may have just 1 of these) If you have named your sheets then those names will appear in the brackets above as opposed to what you see at the moment in my note. Right click on the modules and select remove. When prompted with a question re exporting, just hit no. Then hit File / Close and return to Microsoft Excel and save the file. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message . .. I have a user who has several Excel workbooks that give the macro warning when opened, even though there are no macros in the workbooks. His security is set to high, and I can arrange to lower the setting if it is required, but would prefer to leave it set at the companies default setting (high). Does anyone have any idea why a workbook with no macros would trigger the warning Thanxz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 |
|
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro warning when no macros in workbook
Add-Ins will cause this warning as well. What Add-Ins does he have?
Mike. "Ken Wright" wrote in message ... OK - Your call, but I'm quite happy to take a look at it for you if you want, so the offer's there. You could even delete the data out and send it. In fact, that might be a way to narrow it down. With a copy of the book - Insert a new sheet and then delete all the others. save the book and reopen - If no macro warning, then recopy the original and delete all sheets but the first - save and reopen, and just try and home in on what sheet if any is causing the problem. Maybe you have some controls with macros in somewhere - who knows. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message . .. Yep, tried that too, I think I'll just let him keep answering the security warning, he tends to be annoying anyhow, so... (Yep, I'm a professional. no really....) "Ken Wright" wrote in message ... OK, if you've hit the point where you are fed up, then by all means it on down if you can, and I'll happily take a look. You'd need to take the NOSPAM bit out of email address though. - Just checking though, you did see my last note where I said to try doubleclicking the sheet modules to look for any event macros? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message . .. Yep, on file open, on a system with security set to high. "Ken Wright" wrote in message ... When you open the file, do you get prompted with the warning message?? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message . .. Nope, nothing. Confused yet?(like me?) "Ken Wright" wrote in message ... Doubleclick on the ThisWorkbook object and see if there is any code in there - If so then delete the code and save the workbook. Him emailing you the file shouldn't make any difference - The macro or module would have to be in the file that was being opened at the time to generate the warning message -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message .. . Ken: I did as you suggested, but "Modules" does not appear under the workbook name, Just "Excel Objects". Any other suggestions? Would this change if he e-mailed me the files, rather than me looking at them on his system? BillS "Ken Wright" wrote in message ... You need to delete any empty modules that housed those macros. Hit ALT+F11 and this will open the VBE (Visual Basic Editor) Top left you will hopefully see an explorer style pane. Within this pane you need to search for your workbook's name, and when you find it you may need to click on the + to expand it. Within that you should see the following:- VBAProject(Your_Filename) Microsoft Excel Objects Sheet1(Sheet1) Sheet2(Sheet2) Sheet3(Sheet3) ThisWorkbook Modules Module1 Module2 etc etc (You may have just 1 of these) If you have named your sheets then those names will appear in the brackets above as opposed to what you see at the moment in my note. Right click on the modules and select remove. When prompted with a question re exporting, just hit no. Then hit File / Close and return to Microsoft Excel and save the file. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message . .. I have a user who has several Excel workbooks that give the macro warning when opened, even though there are no macros in the workbooks. His security is set to high, and I can arrange to lower the setting if it is required, but would prefer to leave it set at the companies default setting (high). Does anyone have any idea why a workbook with no macros would trigger the warning Thanxz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 |
|
#14
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro warning when no macros in workbook
I don't know why it happens, other than at one time the
workbook may have contained a macro. I had the same problem with one of my clients and solved it by saving it to another Excel version level and then back to the current version. The warning went away. Barry -----Original Message----- I have a user who has several Excel workbooks that give the macro warning when opened, even though there are no macros in the workbooks. His security is set to high, and I can arrange to lower the setting if it is required, but would prefer to leave it set at the companies default setting (high). Does anyone have any idea why a workbook with no macros would trigger the warning Thanxz . |
|
#15
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro warning when no macros in workbook
Chip Pearson has an explanation and a macro to remove macros.
http://www.cpearson.com/excel/vbe.htm Though I think Debra's suggestions would be the same manually. You might try the macro see if it does better for you, or reports an error. HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Michael D. Ober" <[email protected] wrote in message ... Add-Ins will cause this warning as well. What Add-Ins does he have? Mike. "Ken Wright" wrote in message ... OK - Your call, but I'm quite happy to take a look at it for you if you want, so the offer's there. You could even delete the data out and send it. In fact, that might be a way to narrow it down. With a copy of the book - Insert a new sheet and then delete all the others. save the book and reopen - If no macro warning, then recopy the original and delete all sheets but the first - save and reopen, and just try and home in on what sheet if any is causing the problem. Maybe you have some controls with macros in somewhere - who knows. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message . .. Yep, tried that too, I think I'll just let him keep answering the security warning, he tends to be annoying anyhow, so... (Yep, I'm a professional. no really....) "Ken Wright" wrote in message ... OK, if you've hit the point where you are fed up, then by all means it on down if you can, and I'll happily take a look. You'd need to take the NOSPAM bit out of email address though. - Just checking though, you did see my last note where I said to try doubleclicking the sheet modules to look for any event macros? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message . .. Yep, on file open, on a system with security set to high. "Ken Wright" wrote in message ... When you open the file, do you get prompted with the warning message?? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message . .. Nope, nothing. Confused yet?(like me?) "Ken Wright" wrote in message ... Doubleclick on the ThisWorkbook object and see if there is any code in there - If so then delete the code and save the workbook. Him emailing you the file shouldn't make any difference - The macro or module would have to be in the file that was being opened at the time to generate the warning message -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message .. . Ken: I did as you suggested, but "Modules" does not appear under the workbook name, Just "Excel Objects". Any other suggestions? Would this change if he e-mailed me the files, rather than me looking at them on his system? BillS "Ken Wright" wrote in message ... You need to delete any empty modules that housed those macros. Hit ALT+F11 and this will open the VBE (Visual Basic Editor) Top left you will hopefully see an explorer style pane. Within this pane you need to search for your workbook's name, and when you find it you may need to click on the + to expand it. Within that you should see the following:- VBAProject(Your_Filename) Microsoft Excel Objects Sheet1(Sheet1) Sheet2(Sheet2) Sheet3(Sheet3) ThisWorkbook Modules Module1 Module2 etc etc (You may have just 1 of these) If you have named your sheets then those names will appear in the brackets above as opposed to what you see at the moment in my note. Right click on the modules and select remove. When prompted with a question re exporting, just hit no. Then hit File / Close and return to Microsoft Excel and save the file. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "BillS" wrote in message . .. I have a user who has several Excel workbooks that give the macro warning when opened, even though there are no macros in the workbooks. His security is set to high, and I can arrange to lower the setting if it is required, but would prefer to leave it set at the companies default setting (high). Does anyone have any idea why a workbook with no macros would trigger the warning Thanxz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 |
|
#16
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro warning when no macros in workbook
When you check the workbook, worksheet and form code pages (as described
by Ken Wright, etc.) use Edit|Select All and press the delete key. Even spaces on these pages will trigger the warning. If the warnings still persist, look at http://groups.google.com/groups?thre...%40cppssbbsa04 Solver leaves hidden names that some versions of Excel mistakenly interpret as Excel4 macros. Jerry BillS wrote: I have a user who has several Excel workbooks that give the macro warning when opened, even though there are no macros in the workbooks. His security is set to high, and I can arrange to lower the setting if it is required, but would prefer to leave it set at the companies default setting (high). Does anyone have any idea why a workbook with no macros would trigger the warning Thanxz |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro warning despite no macros in document | Excel Discussion (Misc queries) | |||
| Unwanted Macro Warning for workbook containing no macros | Excel Discussion (Misc queries) | |||
| Macro warning even though macros have been removed. | Excel Discussion (Misc queries) | |||
| macro warning persists even after deleting all macros | Excel Discussion (Misc queries) | |||
| macro warning - but no macros | Excel Discussion (Misc queries) | |||
![BillS[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
