"Enable Macros" prompt does not appear...

[Gshash]

Hi,

I'm using Excel 2007..
When Macro Security is set to- 'Disable all Macros with notification', the "Enable Macros ?" prompt should appear every time a file with Macros is opened, right ?
But it does not appear for my file.. The file size is 4MB; may be that could be the reason.. while opening it, the macro in my file gets disabled by default, my code does not work & the sheet is stuck in 'Design Mode'..

If Macros security is set to low (Enable all Macros.. ) the code works beautifully.. Is setting the security to low, only solution for this ?

The setting applies for every workbook opened on that system, so the users wont be happy if they've to change the security setting to low for my file & change it back to medium / high for others every time...

Pls help !!!