It is probably something to do with the coding, without the actuak code it
is difficult to draw any conclusions.


"Brian Matlack" wrote:


Hi!
My workbook has an opening routine to set the look I want and a
closeing routine to reset the look when I'm done. These codes are in
the "ThisWorkbook" section.
I have a button that I click to simply exit the workbook and part of
the code for that button is suppose to clear all data from certain
cells but for some reason it does not run right. Are the two codes
interfering with each other?
In other words the cleardata macro works if you just run it. but it
doesnot work if you list it and then close the wookbook in the same
code.
Any help would be greatly appriciated by this novice.


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=493504