Are Database Queries considered macros?

Lt. Krul

New Member
Joined
May 6, 2002
Messages
32
Hello all...
I need to know if Database queries the same as macros, i.e. will they still work if macros are disabled?
On a similar note, If they ARE, then how can I prevent macros from being disabled for a particular workbook (when it is opened) that I need the macros for.

Thanks in advance...
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
If a Macro has been digitally signed and you have added this signature to your excel "trusted sources" under the macro menu you should be able to run a macro without being prompted.

Create your own digital signature
Create your own digital certificate
Run the Office 2000 setup program again.


On the Select Features screen in the setup program, expand Office Tools.


Select Digital Signature for VBA projects, click the arrow next to your selection, and then select Run from My Computer.


In Windows Explorer, locate and then double-click the file SelfCert.exe in C:Program FilesMicrosoft OfficeOffice.
Note Because a digital certificate that you create yourself isn’t issued by a formal certification authority, macro projects that are signed by using such a certificate are referred to as self-signed projects. Depending on how your organization uses the digital-signature features in Microsoft Office, you might be prevented from using such a certificate, and other users might not be able to run self-signed macros for security reasons. Learn about digital signatures.

For more information about creating digital certificates, see Help in Visual Basic for Applications.

( source excel help)

Digitally sign a macro project
Make sure you have at least one digital certificate before you try to sign a macro project

Open the workbook or template that contains the macro project you want to sign.


On the Tools menu, point to Macro, and then click Visual Basic Editor.


In the Project Explorer, click the project you want to sign.


On the Tools menu, click Digital Signatures.


Do one of the following:
To use the current certificate, click OK.

To use a different certificate, click Choose, select the certificate you want, click OK, and then click OK again.

More information
Learn about digital signatures

Learn about how security levels and digital signatures work together
( source excel help files)

Setting Security Levels in Office Applications

(source :http://www.microsoft.com/office/ork/2000/three/65ct_4.htm)
 
Upvote 0

Forum statistics

Threads
1,213,583
Messages
6,114,489
Members
448,575
Latest member
hycrow

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top