Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 06-13-2016, 04:39 AM
jeffreybrown jeffreybrown is offline using "save date" in excel. Windows Vista using "save date" in excel. Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Hello Levi & Welcome to the Forum,

You would have to use code...

Something like this placed in the ThisWorkbook module

Code:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    Sheets("Sheet1").Range("A1").Value = Now
End Sub
http://www.rondebruin.nl/win/code.htm
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use a "Save As" button without causing digital signatures to become "Invalid"? jferg Word VBA 0 02-16-2016 03:04 PM
When using "Save and Send" from Excel 2010, the email opens with no ribbons and seems to hang. bjsusol Outlook 1 03-31-2015 11:03 PM
Disable "Save" & "Save As" & "Print" ribbon Villalobos Word VBA 3 07-14-2014 11:37 PM
using "save date" in excel. How to "deactivate" the Excel's SAVE function KIM SOLIS Excel 1 11-05-2011 01:57 AM
"Microsoft Excel Application" missing in the "Component Services" on win08 sword.fish Excel 0 02-26-2010 02:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:38 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft