Before Save Event

**certain_death** · 12-09-2009, 02:29 PM

Hi all

Can anyone help

What I want is a before save event to check if Cells G55:P55 sum -1 to 1 on Group Reporting Worksheet. If it doesnt I want it to display the msgbox.

Am getting a complie error on this, I'm sure I'm close but cant get it to work.

Here is what I am using......

Please Login or Register  to view this content.

Thanks in advance for any help.
Cheers

**JeanRage** · 12-09-2009, 02:40 PM

Hi,

Have you tried ... to use the Application.WorksheetFunction.Sum ...

HTH

**DonkeyOte** · 12-09-2009, 02:45 PM

Remember if you want to cancel the Save to add

Please Login or Register  to view this content.

within the Case Else (and I would probably add "Save Cancelled" to your dialog)

Before Save Event

LinkBack

Thread Tools

Rate This Thread

Display

Before Save Event

Re: Before Save Event

Re: Before Save Event

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions