OrphanBear
03-12-2009, 07:36 AM
Hi All,
Many of my users don't have their macro's enables. I found this code from this site that solved the problem. ("I can't post links yet")
""vbaexpress.com/kb/getarticle.php?kb_id=379""
However, in my spread sheet, in a worksheet module for a commandbutoon, I have a code that has this line.
some code
Activeworkbook.save
some code
The code does some formating and calculating and saves the changes w/out waiting for the user to save or close the worbook. But for some reason it conflicts w/the code above and will not work. I stepped through the code but can't figure out where the issue is. Thanks for any help.
Activeworkbook.save
Many of my users don't have their macro's enables. I found this code from this site that solved the problem. ("I can't post links yet")
""vbaexpress.com/kb/getarticle.php?kb_id=379""
However, in my spread sheet, in a worksheet module for a commandbutoon, I have a code that has this line.
some code
Activeworkbook.save
some code
The code does some formating and calculating and saves the changes w/out waiting for the user to save or close the worbook. But for some reason it conflicts w/the code above and will not work. I stepped through the code but can't figure out where the issue is. Thanks for any help.
Activeworkbook.save