Worksheet_onload : Need VBA

[Istiyak]

Namaste Team,


I need VBA which do something on given topics.


1. Set location on SHEET1 and CELL A1.

2. Auto enable mecro

3. Auto Enable Design mode of Form COntrols.


So user can start work directly, they don't have to do anything else


Any idea plz let me know.


Regards

Istiyak

 

[xld]

You can't auto-enable macros, that would be a rather large hole in security if you could.

 

[Luke M]

As xld said, you can't auto-enable the macros due to security reasons. Similarly, you can't set it to be in "Design mode". (Incidentally, macros themselves don't care about design mode. You can add buttons via VB w/o being in "Design mode") To start on Sheet 1, cell A1 always, you can put this in the ThisWorkbook module.

[pre]

Private Sub Workbook_Open()
Worksheets("Sheet1").Range("A1").Select
End Sub

[/pre]

 

[Istiyak]

HI Luke & Xld


Thanks buddy for your help. some problems have solved but some is steel there.


I have entered 1 Calender Control with ( visible = False ) property....


While i m opening this excel sheet in another place where design mode turn off. it shows that Calendar directly to Viewer which i don't want..


Any suggestion...


Regards

Istiyak