Macros

[Don Niall]

Hi,

Whenever I open a particular workbook I consistently get a
message saying ...'Macros in this workbook are disabled
because the security level is high ..... etc'. However,
all macros have been removed? Meanwhile I dont
particularly want to change any security setting ... Is
there anyway I can avoid continually getting this message
when opening this particular workbook?

Don-

 

[Chip Pearson]

Don,

You need to delete the modules that contained the macros. Even an
empty code module will cause the warning to appear.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Bernard V Liengme]

You need to remove all the Modules in the VB Editor for this file.
Just his once, relax the security and open VBEditor
On the left look for your 'project' - workbook file name, list of sheets and
list of modules.
Delete each module even if it is empty.
Return to Excel and reset security.
Bernard

 

[Don Niall]

Fantastic! Many thanks - it worked a treat ......

-----Original Message-----
You need to remove all the Modules in the VB Editor for this file.
Just his once, relax the security and open VBEditor
On the left look for your 'project' - workbook file name, list of sheets and
list of modules.
Delete each module even if it is empty.
Return to Excel and reset security.
Bernard




.