Enabling Macros

Microsoft OFFICE


  • 1. WSS, Excel, and Sharepoint Designer
    Is it possible to create a dashboard type of web part in WSS using Excel as an input. If so can you point me in the right direction. I'm a non-programmer who can muddle my way through BASIC conversion of sample code to make it do what I want. I have been tasked with redoing our department web site and the tools I have are WSS and Sharepoint Designer. I built our earlier site in FP 2003.
  • 2. analysis toolpak vba add-in for excel
    Does anyone know of a website/book/white-paper/whatever that provides some half-way decent documentation on syntax/use of individual functions (as accessed via VBA) for the analysis toolpack add-in for Excel? Have looked all over but can't seem to find anything useful. Manually recording a macro yields a useable snippet I can cut/paste, but would really like to be able to formulate these commands on my own. Thanks, mac
  • 3. PowerPoint and C++ .NET
    Hi, I'm using VS2008 and added references to Office.dll (v12) and Microsoft.Office.Interop.PowerPoint (v12). The problem is that the TextRange object doesn't have a Text property - although the documentation indicates that it should. Any ideas? I can create a blank table, but I can't input any text into the cells. Thanks. Vinoj
  • 4. vb.net 2005 formatting data in excel 2003 spreadsheets
    I am writing a Visual Basic.Net 2005 desktop application that exports data to individual excel 2003 spreadsheets in separate workbooks. (The data is written to separate workbooks since the workbooks are emailed to different customers.) I am exporting all the data I want to the spreadsheets now. However, I would like to know how to do any of the following: 1. Put the column headers on to the top of each data column. 2. How to put report headers on the first 3 rows of each spreadsheet, 3. How to set the wraparound property one column in particular. I have one column that is varchar(500) and I want this column to wraparound. Thanks!
  • 5. modules removing problem
    Hello, I have problem with this code: For Each objVbc In Workbooks(wb).VBProject.VBComponents If objVbc.Type > 0 And objVbc.Type < 4 Then Workbooks(ActiveWorkbook.Name).VBProject.VBComponents.Remove objVbc Else objVbc.CodeModule.DeleteLines StartLine:=1,Count:=objVbc.CodeModule.CountOfLines End If Next objVbc I have about 30 modules in workbook. Unfortunately, after modules removing by above code always 2 modules aren't remove. What is the reason? Is it possibility to refresh collection VBProject.VBComponents after each removing? Lines deleting works very well, but I can't remove all modules, please help me Greetings, Adax

Enabling Macros

Postby MickeyR » Sat, 15 May 2004 04:54:38 GMT

I have successfully written hundreds of lines of VBA for 
Excel that do all kinds of useful things.  Now I am trying 
to write some VBA in PowerPoint but it keeps telling me 
that macros are not enabled even though I have dropped the 
security level to low.  How do I enable macros in 
PowerPoint or Access?  I have written some code, but I 
can't run it.

Re: Enabling Macros

Postby Mike Walker » Sun, 16 May 2004 07:47:31 GMT

You don't say which version of Powerpoint or Access you are running but both
have different potential issues, the first is powerpoint if you are running
2003 then the tools -> Macro -> security will have the settings if you set
this low and it doesn't help then you may have a policy applied by your
administrator that can force this to stay high without any choice.

Access is the same menu structure in 2003 and has a prompt dialog when you
open up a database with macro/vba in it warning you. If you want to enable
this by some security measure you would have to sign your code and then
trust this signature.


Mike Walker
(Reply via NG)

Similar Threads:

1.Enable macros - security settings are at "enable all macros"

My macros are disabled despite my security settings being at "enable all 
macros".  Any ideas how I fix this?

Many thanks in advance


2.choose default macros Not Enabled / Macros Enable Setting

The following opens the file, accessess the file, no problem.
I need code to "select" the default "macros NOT enabled" Setting.
Otherwise, I'm constantly getting a error message.
I've tried using 'select'.
I need the screenupdating = False, because of size and complexity of file.

Sub BB_Chassis_Draft()
    Application.ScreenUpdating = False
    Workbooks.Open ("S:\10_SALES 

    Application.ScreenUpdating = True
End Sub

3.VBA select default Don't Enable / Enable macros Setting

The file that the following calls up, requires an "enter", 
to accept the default yes/no statement (actually "do NOT
Sub BB_Chassis_Draft()
    Application.ScreenUpdating = False
    Workbooks.Open ("S:\10_SALES 
    Application.ScreenUpdating = True
End Sub

4.Word & Enable Macros and Disable macros

When I open Word, I get the Enable-disable macros box.  Why

5.Macro to enable macros when document opened

6. Enable Macros with a Macro!

7. Removing Excel message to enable macros or disable macros

8. "openinf file..."ENABLE MACROS...DISABLE MACROS"

Return to Microsoft OFFICE


Who is online

Users browsing this forum: No registered users and 26 guest