Auto Open in excel + vba

Posted Date: 09 Feb 2008	Resource Type: Code Snippets	Category: General
Author: Deepika Haridas	Member Level: Diamond
Rating:	Points: 7

Procedure which will be called automatically when a excel workbook is opened..
All steps are performed on excel open..
Here, I have passed some message which will be displayed on when I open the excel.


Sub Auto_Open()


    With Application
        .Calculation = xlAutomatic
        .MaxChange = 0.001
        .CellDragAndDrop = False
        

    End With
        disableCut

Application.EnableEvents = True
'hidegrids
msginit = "Green cells are for data entry" & Chr(13)
msginint = msginit & "CAUTION : DO NOT USE CTRL X OR CUT PASTE WHILE DATAENTRY. " & Chr(13)
msginit = msginint & "Red labels indicate compulsory fields" & Chr(13)
'msginit = msginint & "CLICK THE BUTTON ON TOP LEFT (With Tick Mark) TO CHECK THE ERRORS IN A SHEET" & Chr(13)
MsgBox (msginit)
MsgBox "Please enable macros to be able to use the excel utility"
End Sub

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Vba . Open . Excel . Auto .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.


	Previous Resource: Picture blurry zooming using JAVA
	Return to Discussion Resource Index
	Post New Resource
	Category: General

Post resources and earn money!