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