Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open workbook properties on save.
Please can someone tell me what the VBA code is to open the Workbook
properties dialogue box when a user first saves an Excel workbook? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open workbook properties on save.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean) Dim dLastSaved As Date On Error Resume Next dLastSaved = Me.BuiltinDocumentProperties("Last save time").Value If Err < 0 Then Application.Dialogs(xlDialogProperties).Show End If End Sub This code is to be pasted into ThisWorkbook Code HTH -- AP "Colinhp" a écrit dans le message de news: ... Please can someone tell me what the VBA code is to open the Workbook properties dialogue box when a user first saves an Excel workbook? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If workbook is open, save workbook? | Excel Programming | |||
Using interop.excel to open a workbook, the workbook doesn't ask to save changes. | Excel Programming | |||
Why when i have more than one workbook open and i want to save ch. | New Users to Excel | |||
Locking VBA code via Project properties but cannot save the workbook over itself | Excel Programming | |||
What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming |