View Single Post
  #8   Report Post  
bala_vb bala_vb is offline
Senior Member
 
Location: Hyderabad
Posts: 237
Default

Quote:
Originally Posted by Nadine View Post
Thank you.

"Dave Peterson" wrote:

Debra Dalgleish shows how to clean up all the remnants of macros:
http://www.contextures.com/xlfaqMac.html#NoMacros

Nadine wrote:

I had been playing with some macros in a book I have. I didn't think I had
saved any of them. Now when I open that workbook, I get a message that says
macros are disabled because the security level is set to High... I'd like to
delete these macros that somehow got stored but when I go to Tools, Macros,
Macros the option to Delete one is not visible - it is grayed out.

Does anyone know how to remove these macros that I was fiddling with and
don't want to keep? Thank you.


--

Dave Peterson
.
one of the quickest way to disable/restrict the macros is

Saveas macro disable workbook.

Your macros will be automactically removed and disabled as well.
__________________
Thanks
Bala