Compile Error & Error recording Macro

[mikiel111]

Whenever i open a very particular excel file the VB ediot will load up and I get this message
"Compile Error:
Expected: expression"

I also get this message when trying to run a macro which previously worked or when closing this particular excel file.

When i try to record a macro I`m asked to name it then immediately get the message "unable to record"

Before I got this message I previously playing around with macro recording. I`d record many then delete the module when i wanted to change something about it.

 

[mole999]

at the very top of the macro do you have

Option Explicit

that will help identify where the issue has been introduced

 

[mikiel111]

bear in mind i know nothing about VBA and the macro was done & edited for me by other users from this forum*
*unique combinations generator

If by that you mean is it written in the vba code of the only macro I currently havent deleted then no (this macro has worked flawless before).

 

[mikiel111]

I solved it be deleting the module and deleting the icon with assigned macro and re-pasting the VBA and making another macro. In my previous attempt to fix it I left the icon with assigned macro and it wouldnt work.