Workbook sheet change event prompts save

**shg** · 10-29-2009, 01:17 PM

The code I posted doesn't prompt at all, does it? It just saves worsheeets ending in "sd" after any manual change.

**pprseller** · 10-29-2009, 01:39 PM

I have code for "before save" prompting user if they are sure they want to save. So I took that out and your code works fine except on every cell change the workbook saves and it takes about 15 seconds to save each time (it's a large workbook!). How can I stop that? (This a worksheet where the user will be filling in 15 fields so that will be too long to wait it out each time a cell is changed.)

**shg** · 10-29-2009, 01:41 PM

So ... what behavior do you want?

**pprseller** · 10-29-2009, 01:52 PM

I want the worksheet to be saved when the user is done using it - all the way done, not cell by cell.

**shg** · 10-29-2009, 02:08 PM

If "done" means when the sheet is deactivated, then

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
    If LCase(Right(Sh.Name, 2)) = "sd" Then Me.Save
End Sub

**pprseller** · 10-29-2009, 02:12 PM

Thanks, that will do it. I appreciate your help.

Workbook sheet change event prompts save

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Workbook sheet change event prompts save

Re: Workbook sheet change event prompts save

Re: Workbook sheet change event prompts save

Re: Workbook sheet change event prompts save

Re: Workbook sheet change event prompts save

Re: Workbook sheet change event prompts save

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions