the FILE, I cancel the default "save" operation and issue commands
> to update the Oracle database.
>
> There's LOTS of perfectly valid reasons to recommend using the Save event.
> It's all part of the Design process...
>
> Paul
>
>
>
admin2009
To: excel-macros@googlegroups.com
Sent: Tuesday, April 14, 2009 10:14:24 PM
Subject: $$Excel-Macros$$ Re: Autorun a macro on save
Hi Hamster,
I don't know your requirement. But with design perspective writing a code
around save is not recommended because you might hit save butto
Hi Hamster,
I don't know your requirement. But with design perspective writing a code
around save is not recommended because you might hit save button or Ctrl + S
many a times unknowingly while working with excel. Just check it out.
have fun,
ddadmin.
On Mon, Apr 13, 2009 at 10:11 AM, Hamster wro
Thanks, Dave, that's what I was looking for!
On 3 Apr., 06:54, Dave Bonallack wrote:
> Hi Hamster,
>
> If you go to the Workbook window of the VBA, where your Workbook Open macros
> live, set the left drop-down to Workbook, then in the right drop-down,
> select: BeforeSave.
>
> You will se a
Hi Hamster,
If you go to the Workbook window of the VBA, where your Workbook Open macros
live, set the left drop-down to Workbook, then in the right drop-down, select:
BeforeSave.
You will se a blank sub like this:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Bool
