Hi, I hope someone can help me.
I've been working on a spreadsheet for months, and had initially recorded a macro to delete the contents of several cells on a page. I no longer need this, so I deleted it with the Macro dialog box, and then went into the VB screen and deleted the module. I saved the book, re-opened it, and it asks whether I want to enable the macros! It now also asks if I want to enable macros when I open any other book. I know that there are many posts about this, but none of the solutions posted have been able to solve this.
With all the books I open, in the VB screen, double clicking on "This Workbook", and looking under Workbook (not General) I get
Private Sub Workbook_Open()
End Sub
which I can't delete. Is this the culprit, or is there something else I should look at?
Thanks for your help,
R.
I've been working on a spreadsheet for months, and had initially recorded a macro to delete the contents of several cells on a page. I no longer need this, so I deleted it with the Macro dialog box, and then went into the VB screen and deleted the module. I saved the book, re-opened it, and it asks whether I want to enable the macros! It now also asks if I want to enable macros when I open any other book. I know that there are many posts about this, but none of the solutions posted have been able to solve this.
With all the books I open, in the VB screen, double clicking on "This Workbook", and looking under Workbook (not General) I get
Private Sub Workbook_Open()
End Sub
which I can't delete. Is this the culprit, or is there something else I should look at?
Thanks for your help,
R.