"Enable or Disable" macros dialog box for excel 2

[Mack2]

I am trying to disable the "Enable Disable macros" Dialog box when I open an excel spreadsheet. I have deleted all of the macros and modules within the spreadsheet. And the dialog box still comes up! All I want is to not have that macros dialog box to NOT pop up. PLEASE HELP! THANK YOU IN ADVANCE!

 

[CBasicAsslember]

I can tell you how to make it do that but you will have to figure out the details.

Open up a Workbook.
Right click on one of the sheet tabs.
Select 'Insert' (A dialog box will pop up)
Select "MS Excel 4.0 Macro"

That will insert a macro sheet that will not show up in the VBA project window.

In VBA code you could add one with:

Sheets.Add Type:=3



Type 3 happens to be a xlExcel4MacroSheet

 

[SkipVought]

ctr+F11 - inserts a Macro Sheet.

alt+F11 - Toggles to the VB Editor.

I have on occasion, made this mistake.

Skip,

_[red][/red]

 

[Mack2]

I am having the same problem as above. I open a workbook and the "select macro" dialog box comes up. I have no code or macros within the workbook. I ran the code below, and no macro sheets came up. Thanks for your help in advance!
Dim c
Dim a As Long
Dim temp

Set c = ActiveWorkbook.Sheets

For Each c In Sheets
temp = c.Name
Sheets(temp).Visible = True
Next

 

[Mack2]

Forget the last post, it is working!