Re: $$Excel-Macros$$ BeforeSave not working

2015-05-05 Thread mburkett
Yes On Tuesday, May 5, 2015 at 1:59:59 AM UTC-4, Vabz wrote: > > was macro was enabled on your system? > > On Tue, May 5, 2015 at 1:14 AM, mburkett > wrote: > >> One more oddity. I opened the file on another computer on our network and >> it worked perfectly. Both have the same rights so there m

Re: $$Excel-Macros$$ BeforeSave not working

2015-05-04 Thread Vaibhav Joshi
was macro was enabled on your system? On Tue, May 5, 2015 at 1:14 AM, mburkett wrote: > One more oddity. I opened the file on another computer on our network and > it worked perfectly. Both have the same rights so there must be some > setting within Excel? Ideas? > > > On Monday, May 4, 2015 at

Re: $$Excel-Macros$$ BeforeSave not working

2015-05-04 Thread mburkett
One more oddity. I opened the file on another computer on our network and it worked perfectly. Both have the same rights so there must be some setting within Excel? Ideas? On Monday, May 4, 2015 at 1:49:16 PM UTC-4, mburkett wrote: > > I need it to do the macro every time the file is saved. Also

Re: $$Excel-Macros$$ BeforeSave not working

2015-05-04 Thread mburkett
I need it to do the macro every time the file is saved. Also I tried your code and tried saving and closing the file. In both instances, it didn't run the code. Could there be some setting I am missing in security ect? On Monday, May 4, 2015 at 1:22:12 PM UTC-4, Vabz wrote: > > Change 1st line t

Re: $$Excel-Macros$$ BeforeSave not working

2015-05-04 Thread Vaibhav Joshi
Change 1st line to.. Private Sub Workbook_BeforeClose(Cancel As Boolean) Cheers!! On Mon, May 4, 2015 at 10:32 PM, mburkett wrote: > I have some very simple code that I put in the workbook's BeforeSave > event. When I click save the code doesn't run. Any ideas? I've never used > these private

$$Excel-Macros$$ BeforeSave not working

2015-05-04 Thread mburkett
I have some very simple code that I put in the workbook's BeforeSave event. When I click save the code doesn't run. Any ideas? I've never used these private subs so I may need to change a setting??? Here is the code: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)