Thread: Saving
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Saving

Uh, the Excel icon?

It is the Excel image at the top left of the worksheet next to the worksheet
name.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"eman" wrote in message
...
Where exactly is the 'Excel icon on the worksheet'?

"Bob Phillips" wrote in message
...
Put this in Personal.xls


Public WithEvents App As Application

Private Sub App_WorkbookBeforeClose(ByVal Wb As Workbook, Cancel As
Boolean)
Wb.Save
End Sub

Private Sub Workbook_Open()
Set App = Application
End Sub


'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code



--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"eman" wrote in message
...
I have a small program called 'Notebook' that when I close it, it saves
automatically without selecting File/Save as. Is it possible to make this
in Excel? I mean closing Excel without selecting save as each time but it
saves automatically on closing!