$$ 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 button or Ctrl + S
many a times unknowingly while working with excel. Just check it out.
have fun,
ddadmin.
On Mon, Apr
all part of the Design process...
Paul
--
*From:* ddadmin2009 ddadmin2...@gmail.com
*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
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
Thanks, Dave, that's what I was looking for!
On 3 Apr., 06:54, Dave Bonallack davebonall...@hotmail.com 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:
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
