Excel macro warning

[Antoniov.]

I've got a tedious problem.
I wrote a complex datasheet for my customer; to make easy some works I wrote a macro, I uset it then removed form file.
But now every time my customer open execl file he see a warning message about macro!
How I can remove this message (I deleted all macors!).

Cheers
Antonio Vigliotti

[Ron Kinner]

Can you create a new blank speadsheet and copy the pages from the old to the new? Try it with one page and see if it still shows the macro warning.

Ron

[Perignon]

Antonio,

Normally, this warning should occur only when Excell is opening files containing macros (because worms are fond of macros apparently). If all and any files are concerned, you may be whishing to consider Ron's tip and/or add instructions so that your macros apply to a limited number of data sheets.

Alain.

[Antoniov.]

Customer worksheet is too complex to make simply copy and past. I will avoid this operation, I prefer read warning message!

Antonio Vigliotti

[Paul Starr · Accepted solution]

Hi Antonio,

You can turn off the warning message in Excel by clicking on the Tools menu, selecting Options, and clicking on the Security Tab. Next Click on the button labeled Macro Security and set the Security Level to Low. WARNING: Make sure your customer has up to date anti-virus software running! There are a number of viruses and worms that may be activtated by Excel or Word macros.

[Bruno Ganino]

Hi Antoniov,
you see a warning in Excel 2000 when you open a document?
This is possible because it is protect.

Excel lets each user decide under what conditions macros will be allowed to run. By selecting Tools, then Macro, then Security, the user can select any of three ways to handle macros:

- High security.
Macros that have been digitally signed by someone the user trusts can run, but all other macros are prevented from running.

- Medium security.
Macros that have been digitally signed by someone the user trusts can run, but all others will generate a warning dialogue that asks for the user's permission before running. (This is the default setting).

- Low security.
All macros are allowed to run without warning. (This is not a recommended setting).

This vulnerability affects the types of warnings that users with security set to medium would see, and the conditions under which they would see them.

HTH
Bruno

[Ron Kinner]

http://www.office-addins.com/microsoft-excel-add-ins/Macro-Remover.html

might help but it costs $30.

You don't say what version of Excel you are using. There is a patch for 97 which fixes a problem with warnings when there is no macro. http://support.microsoft.com/?kbid=830356

Ron

[Antoniov.]

Sorry for late answer and points submition.
Paul, your hint worked; I set low protection level because PC has antivirus and usually is not connected to internet.
However, my trouble is message WITHOUT macro. This is a bug of Excel.

Antonio Vigliotti

[Ganesh Babu]

hi Antoniov,
Just to make sure that there is no macro.. can u try this

Goto Tools->Macro-> Visual Basic Editor

this will show u a list of Excel objects in the left hand side..

goto each object (sheet1, 2, 3 & Thisworkbook) and make sure there is no code written in it..

Ganesh

[Ganesh Babu]

is this message appearing only for this excel file or for every new excel file of that user??

Ganesh

[Antoniov.]

Ganesh,
I own created the excel file from new. I used a macro to make easy some works and then I removed the unique macro written. However I already checked for macro menu.

Thanks
Antonio Vigliotti

[Marcin Golembski_1]

Ganesh is almost there.

Goto Tools->Macro-> Visual Basic Editor. On the left, besides 'Microsoft Excel Objects', you should also see 'Modules'. Check each object underneath 'Modules' and if there's no code written in them delete the 'Modules' branch completely. The warning message should be gone.

[ganesanrajaiyan]

Hi,

Understood the problem, i thought of that u are using some excel workbook open event macros, and also while saving and before sending to customer you might not be delete this workbook open even macros i hope, this macro while opening the workbook it will automatically work without users permission if the macro security level is high it will ask the user to enable or disable macros

Just go to the visual basic editor and double click the "Thisworkbook" object in the left side VBAproject and insert the below code this code will do the action of while before closing your workbook this macro will delete all macro from your workbook so that now your macro workbook will be macro free workbook...

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim x As Integer
Dim Proceed As VbMsgBoxResult
Dim Prompt As String
Dim Title As String

Prompt = "Are you certain that you want to delete all the VBA Code from " & _
ActiveWorkbook.Name & "?"
Title = "Verify Procedure"

Proceed = MsgBox(Prompt, vbYesNo + vbQuestion, Title)
If Proceed = vbNo Then
MsgBox "Procedure Canceled", vbInformation, "Procedure Aborted"
Exit Sub
End If

On Error Resume Next
With ActiveWorkbook.VBProject
For x = .VBComponents.Count To 1 Step -1
.VBComponents.Remove .VBComponents(x)
Next x
For x = .VBComponents.Count To 1 Step -1
.VBComponents(x).CodeModule.DeleteLines _
1, .VBComponents(x).CodeModule.CountOfLines
Next x
End With
On Error GoTo 0

End Sub



before using this code you should take a back up of your macro file because it will erase all macros in your workbook

This macro running prerequestics is required

Tools - options - Macro settings - Trust access to the VBA project object model should be enabled

Pls let me know if any scrutiny...


Thnx
Ganesan R