M
mr_teacher
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.!
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.!