Hi,

Sure there is an easy answer to this one but it has me stumped!!

i have programmed a spreadsheet and it includes several macros and all seemed to be working fine. I closed it and it opened up fine again - macro security is set to medium on the computer.

However, ever so often when I open the file, it opens up without asking if I wish to Enable Macros and when I click on a command button to trigger a macro it gives the message that the Security setting is set to high - but when I check this it is still set to Medium.

If the workbook is then closed and opened again it will generally work no problems - only once have I had to close it twice and then reopen to get it to function correctly.

Any suggestions on what may be causing this issue and what I can do to put it right will be greatly appreciated.!!