PDA

View Full Version : Excel crashes using Force macros code



jrb
02-22-2011, 04:40 PM
Just wondering if anyboby has some ideas as to why Excel is hanging up when I use Ken Puls code to force the enabling of macros. (http://www.vbaexpress.com/kb/getarticle.php?kb_id=379)

If I use this code and have more than one sheet opened with this code Excel will freeze up.

Any ideas or thoughts?

mdmackillop
02-23-2011, 01:43 AM
What version of Excel?

jrb
02-23-2011, 05:59 AM
Thanks for the reply MD. Sorry about that it is all 2007.

I did some looking around and found

http://www.excelguru.ca/node/91

which led to

http://social.answers.microsoft.com/Forums/en-US/officeprog/thread/cdf9885f-f4e3-4424-8fab-7adc541d1c6f

Haven't tested it yet to see if it is a good fix