Macros

D

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-
 
C

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
 
B

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
 
D

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




.
Click to expand...
 
Top