VBA macro does not save
Creating a new module probably resets the project.
"Brian Gideon" wrote in message
oups.com...
Josh,
Thanks for the reply. While I was going through your suggested
procedure I discovered (by accident) that if I create a new module and
put the code in there then it will save correctly. The code is lost if
I put it in Sheet1, Sheet2, Sheet3, or ThisWorkbook, etc. despite the
fact that it can be executed and debugged without problems. I'm still
not exactly sure what's going on, but at least I have a work-around for
now. Thanks.
Brian
|