Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable Macro - default //
Hi !!
1.) How can i make the workbook open with Macros Enabled - always, w/o user being asked for the option to choose - Disable or Enable. 2.) Also , the macros written in the file should should not be visible / accessible to the users. It should be hidden . Pls. advise. rgds // Sk. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable Macro - default //
Hi, Sansk_23,
1.) How can i make the workbook open with Macros Enabled - always, w/o user being asked for the option to choose - Disable or Enable I do not believe that this is possible. The user's ability to choose to enable macros is an intentional (and proper) design feature. 2.) Also , the macros written in the file should should not be visible / accessible to the users. It should be hidden . Try password protecting the VBA project: In the VBE, Menus | Tools | VBAProject Properties | Protection | Lock Project for viewing [x] | Enter and confirm Password | OK Save, close and re-open the file. --- Regards. Norman "sansk_23" wrote in message ... Hi !! 1.) How can i make the workbook open with Macros Enabled - always, w/o user being asked for the option to choose - Disable or Enable. 2.) Also , the macros written in the file should should not be visible / accessible to the users. It should be hidden . Pls. advise. rgds // Sk. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable Macro - default //
1.) How can i make the workbook open with Macros Enabled - always, w/o
user being asked for the option to choose - Disable or Enable. I think you have just considered to decrease the macro/security level to low, is it true? Alternatively, if you don't like to decrease the security level, you can get a digital certificate for running Excel Macros under High Macro Security. http://www.excelsig.org/Tips/0409_di...rtificates.htm Emiliano |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable Macro - default //
Hi,
#1. You would need to put the users Excel Macro Security to Low which is generally considered dangerous because it applies to ALL Excel files opened on that user's machine. You might consider: "If you haven't already done so, set the macro (macro: An action or a set of actions you can use to automate tasks. Macros are recorded in the Visual Basic for Applications programming language.) security level to Medium or High. How? On the Tools menu, click Options. Click the Security tab. Under Macro Security, click Macro Security. Click the Security Level tab, and then select the security level you want to use. Open the file or load the add-in (add-in: A supplemental program that adds custom commands or custom features to Microsoft Office.) that contains macros certified by the macro developer that you want to add to the list. In the Security Warning box, select the Always trust macros from this publisher check box. Note If the Security Warning box does not display the Always trust macros from this publisher check box, the macros are not digitally signed (digital signatu An electronic, encryption-based, secure stamp of authentication on a macro or document. This signature confirms that the macro or document originated from the signer and has not been altered.). You cannot add this macro developer to the list of trusted sources without a digital signature." This is from the 2003 help system - searching help on "Trusted Publishers" There are links there to a discussion of digital signatures. #2: If you mean that you want the macro to not displayed when the Tools, Macro, Macros dialog box is displayed, then you should make the macro a Private Sub myMacro() End Sub If you mean so they can't get to it in the VBE, then in the VBE choose Tools, VBA Project Properties, Protection tab, check Lock project for viewing and add a Password. Cheers, Shane Devenshire Microsoft Excel MVP "sansk_23" wrote in message ... Hi !! 1.) How can i make the workbook open with Macros Enabled - always, w/o user being asked for the option to choose - Disable or Enable. 2.) Also , the macros written in the file should should not be visible / accessible to the users. It should be hidden . Pls. advise. rgds // Sk. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enable default to show gridlines on an inserted worksheet? | Excel Discussion (Misc queries) | |||
How can I 'Enable Automatic Refresh' for Query Refresh by default | Setting up and Configuration of Excel | |||
choose default macros Not Enabled / Macros Enable Setting | Excel Programming | |||
VBA select default Don't Enable / Enable macros Setting | Excel Programming | |||
enable macros as default | Excel Programming |