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

Hello Brian,

It would help if you post the code that is causing you problems.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=493504

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