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.
Enabling Macros
2 posts
• Page 1 of 1
- MS Office Access
- internet explorer
- FLASH
- dotnet framework
- FLASH
- Windows
- sharepoint
- DATABASE
- ASP.NET
- windows ce
Jump to:
- 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
Next
Enabling Macros
by MickeyR » Sat, 15 May 2004 04:54:38 GMT
Re: Enabling Macros
by 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. Rgds 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 Vie
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
MANUALS\Z_JFS\0_Spread_Sheets\10_Modifications\7_NEW
2006\4_Updating\BB-Pup-Chassis-2006_R1C0.xls")
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
MANUALS\Z_JFS\0_Spread_Sheets\10_Modifications\7_NEW
2006\4_Updating\BB-Pup-Chassis-2006_R1C0.xls")
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
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 26 guest