Auto-Enable Macros at Startup in Excel 4

[hahnsm]

I am having a lot of problems getting my macros to be automatically enabled at the startup in Excel 2000. I have changed my security setting to low but other users who use this file do not have the same settings and so they are prompted at startup to enable macros. I have read many posts about creating a script or changing the registry and do not understand how to do this. Also, there has to be an easier way to enable the macros at the startup through a sub auto_open or the workbook_open.

I am not very familiar with VBA but looking at the Object browser I have noticed XLRunAutoMacro, XLAutoOpen, and MacroOptions. Can any of these be used to enable macros at the startup??

Thanks in advance!
Sadie

 

[xitu]

Assuming you have this macro


Sub test()
Your code
End Sub

Add this to your code

Sub Autpen()
test
End Sub

Hope this works

 

[hahnsm]

Thanks for your response but I don't want all of my macros to RUN at the startup. When Excel open, there is prompt to Enable or Disable macros. I would like for this prompt to NOT show up. Is that possible??
People who are going to be using my workbook dont understand that they need to enable the macros. Thanks
Sadie

 

[acron]

If macros are disabled, the macro to enable macros would be disabled.

If it was possible to enable macros by using code then there would be no security at all.

What you need to do is to investigate the use of digital signatures. See the following MSDN aricle :

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnimo00/html/combat.asp.

A.C.

 

[Chattin]

Have a look at this page too

http://j-walk.com/ss/excel/tips/tip100.htm

about hiding sheets etc bit

Chris ;-)

Visit

http://www.mrexcel.com/board/index.php

for great xl and xl/VBA help

 

[hahnsm]

Thanks for the websites A.C. and Chris! Hopefully they will help me out!
Sadie

 

[Harlequin007]

Sadie

I've recently developed a workbook for our guys and have inserted my own security certificate.

That way, they accept my certificate and never get asked again.

----------------------------
Cogito Ergo Sum

http://www.discworks.co.uk

----------------------------