Finding and deleting macro in a workbook

S

starguy

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

what's that mystery
 
T

tim m

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.
 
M

Max

OT here, sorry ..
(just to comm with the OP: starguy)

starguy,

I've responded at least twice <g> to your latest follow up in the thread:
Re: dynamic formula needed
[View thread: http://www.excelforum.com/showthread.php?threadid=551813 ]

Here's what I replied to you (~10 hours ago):
-------
starguy said:
can I copy this formula in Main to the right for more subjects like
2.2, 2.3 and so on and same way in those sheets.
Click to expand...

Yes, of course. Just extend to suit ..

-------
I can see my replies getting through from where I'm currently posting (MS
Office Online webpage) but it no longer seems to propagate through to
Excelforum. Maybe that thread's too deep ?? (I dunno <g>)

Just thought I'd piggyback this thread to get through to you ..
 
Top