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 al
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 askin
if I wish to Enable Macros and when I click on a command button t
trigger a macro it gives the message that the Security setting is se
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 wor
no problems - only once have I had to close it twice and then reopen t
get it to function correctly.

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

--
mr_teache
-----------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...fo&userid=3435
View this thread: http://www.excelforum.com/showthread.php?threadid=54301