This is behaviour by design. The point of disabling macros is to ensure
code does not execute. Excel does not know that your solution is completely
harmless and is obeying the master security setting.

If you want the login code to execute you'll have to ensure the macros have
been enabled before your workbook loads.


--
Regards,


Bill Lunney
www.billlunney.com

"Johan" wrote in message
...
Good Day all

i have added a login box to my spreadsheet, but it only executes when i
enable macro's. How can i set this login box to the disable macro, please
any help will be appreciated.

Thanks Johan