Kalau disetting read only lebih merepotkan ya?
On 9/3/13, hendrik karnadi <[email protected]> wrote: > Coba copas macro ini pada VBAProject This Workbook, > > Private Sub Workbook_BeforeClose(Cancel As Boolean) > Application.DisplayAlerts = False 'dialog box tidak muncul > ActiveWorkbook.Close SaveChanges:=False 'perubahan tidak disimpan > End Sub > > Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As > Boolean) > Cancel = True 'tidak bisa save > End Sub > > Salam, > HK > > > ________________________________ > From: Andy Ajhis Ramadhan <[email protected]> > To: "[email protected]" <[email protected]> > Sent: Monday, 2 September 2013, 9:46 > Subject: [belajar-excel] Perubahan Excel tanpa Saving. > > > > > Dear, > Be- Excel > > Bagaimana caranya agar Excel yang kita buat saat ada perubahan ditutup tidak > meminta saving ? > karena user hanya bersifat melihat tetapi tidak memiliki hak saving. > > Terima Kasih. > Andy >
