macros warning

Excelled

New Member
Joined
Aug 15, 2002
Messages
31
I created a spreadsheet with a macro in it.
Removed the macro after running the macro from it. Whenever I open this sheet now, it asks me if I want to "disable macros" or "enable" them.
Even though I dont have macros at this point on that spreadsheet, the message still keeps popping up. Is there a way to avoid that.
I found out that if you lower your security setting in excel, the message will disappear.
But, since there are no macros in it now, is there a way to make it disappear, while keeping my security settings the way they were?
Please helppp !!
 
Hi
The thing is when I did a view code for each sheet, I got no code on every sheet under the "General" option. But under the "Worksheet" option, I got this piece of code
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub
I erased it, but it keeps coming back.?
 
Upvote 0

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Only check "General" if you click "Worksheet" Excel will automatically add the "Event" every time you open the editor to "Worksheet."

If you delete the just added Worksheet Event and do not open the editor again under Worksheet, the Event will be gone. JSW
 
Upvote 0

Forum statistics

Threads
1,215,945
Messages
6,127,851
Members
449,411
Latest member
adunn_23

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top