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

--
Brian Matlac
-----------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...nfo&userid=350
View this thread: http://www.excelforum.com/showthread.php?threadid=49350