Kalau read only tetap saja meminta save as. hehehe ----- Pesan yang Diteruskan ----- Dari: Eka Subyantara <[email protected]> Kepada: [email protected] Dikirim: Selasa, 3 September 2013 11:40 Judul: Re: [belajar-excel] Perubahan Excel tanpa Saving.
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 >
