You will get that message depending on how you have youir security settings
in excel via 'Tools'...'options'....'security'....'macro security'

to see what macros you have in a sheet you should be able to go
'tools'...'macro'...'macros' and see a list of any macros you have. You'd
have to know of course which macro name is causing you the problem before
deleting it.

"starguy" wrote:


i have saved as a workbook and made some amendments in it to use for
some other purpose. when I open that new workbook it sometimes gives a
message that macro cannot be run because of security level (explaining
message in my own words) but this do not happen each time when I open
that book.

what's that mystery.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=554561