Hi All
As we all know Excel has a save button along the top and a save command.
When we select or press save Excel is obviously running a program to do it. Where is this program and can users edit it? I want access to that programming to stick a macro inside so that whenever anybody presses save the macro executes.
Thanks All
Titantula!
You don't have access to that code, but there is a Before Save event procedure where you can trap any workbook save event and run your code.
Guide: Run A Procedure Before Saving A Workbook
https://www.engram9.info/excel-vba-p...-workbook.html
Put this in the ThisWorkbook code module.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) 'Your code here End Sub
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks