New Tip everytime excel opens

B

Bhuktar S

Is there a tutorial/guideline for adding the feature of providing ti
whenever a particular excel file opens? I have made an excel file fo
other staffs to use & would like to help them to do their job best
easy way
 
D

David McRitchie

Hi "Bhuktar S >" <<Bhuktar.S.16e8ea@,
Don't know what you mean by tip.
You might make the first worksheet contain a description
of the workbook and how to use it.

When you save the file for them make sure you have that
sheet open. Or if you don't mind having a macro, you
can have the macro always open the workbook to the first sheet
(meaning the leftmost sheet tab)..

You can create Event macro for when the workbook is
opened. Right click on the Excel logo to left of the worksheet menu's,
then pick "View Code". This brings up "ThisWorkBook" and into
it you can insert the following code :

Private Sub Workbook_Open()
Sheets(1).Activate
End Sub
 
Top