When I run a vba timer code in vba I get a forbidden error how to fix it?

Public Sub EventMacro()
'... Execute your actions here'
MsgBox ("xixi")
alertTime = Now + TimeValue("00:00:05")
Application.OnTime alertTime, "EventMacro"
End Sub

I get the error
macro can't use in the workbook, maybe forbidden or not enable. How to fix it ?

I already enable the macro.

Hi,

Can you post the exact error message & error number you see?

Thanks

Hi,

Is this a Shared or Protected workbook OR is it a simple macro enabled file just saved to your computer?

If it is a Shared or Protected, have a look at this link;

https://answers.microsoft.com/en-us/...a-80016f11c382

You uploaded an xlsx file. By definition, it does not contain macros; the file format purposefully does not allow it.

Move your code to a standard module, not the sheet module

Ok, try creating a new Macro Enabled (.xlsm) workbook, paste your data in 'Paste Values' & add your Macro into a Module - Use 'Insert Module' & run it.

I'm not getting any errors when I do this.