Forcing Macros - For people who don't save documents enough!!!

**flipjarg** · 01-10-2012, 12:57 PM

I have done some searching and tried a few search results but haven't found anything that has actually worked. I have a few people who do not save their sheets ALL DAY! I need to force them to auto save when they change a cell. Does anyone have a good way to force someone to use macros when they open the sheet?

**jeffreybrown** · 01-10-2012, 01:08 PM

Have you conduted a keyword search here on this forum or through google/yahoo?

One option...

http://www.vbaexpress.com/kb/getarticle.php?kb_id=379

**flipjarg** · 01-10-2012, 01:51 PM

As I mentioned in the beginning of my original post, I have done some searching. The link you posted looks familiar but I will give it a shot.

Thanks!

**jeffreybrown** · 01-10-2012, 01:57 PM

Originally Posted by flipjarg

As I mentioned in the beginning of my original post, I have done some searching. The link you posted looks familiar but I will give it a shot.

Thanks!

Sorry I missed that part

Let us know if you need any further help

**flipjarg** · 01-10-2012, 05:05 PM

Hey, great, that one works! Thank you! However, there is one problem. When I put my macro in to save every time a cell is edited, my macro doesn't work. When I remove the "force macros" code, my macro works.

My Macro (this code is placed under the worksheet that is being edited):

' SAVE THE FILE UPON CELL EXIT WITHOUT PROMPTING THE USER... SAVES IN BACKGROUND.
Private Sub Worksheet_Change(ByVal Target As Range)
    Application.DisplayAlerts = False ' TURNS ALERTS OFF

    ActiveWorkbook.SaveAs ThisWorkbook.FullName

    Application.DisplayAlerts = True ' TURNS ALERTS BACK ON
End Sub