|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
|
|||
|
|||
|
Macro Security
Hello,
Could someone please help me to do the following... I am using Excel 2000, and have macros in the workbook, what I want is that when the workbook is activated (and the user has selected enable macros) is to change the security setting in excel...I want to move it to low so the user doesnt have to click enable macros all the time My second problem is this... in this workbook of mine I have data linked to an external source, the user will always need to update the links to the other workbook, is there a way to automatically select yes to this question everytime the workbook opens??? Thanks, |
|
#2
|
|||
|
|||
|
U can use sendkey funtion...See more to: http://forums.devshed.com/showthrea...ghlight=sendkey
|
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > Macro Security |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|