Helloooo,
I have recently been redesigning some forms for my accounts system and got very frustrated with having to use the 'Merge & Centre' button every few seconds, so found a way, to bind a key to a Macro that did it for me. But now i no longer need the macro and have deleted it, but every time I open the form I now get an 'Enable / Disable' pop-up.
The only way i can find to stop the pop-up is to set the Macro Security to low, but i would rather not do this -
1) For security reasons
2) The form will not be used by me, and was designed to be as simple as possible to use by our Rwandan staff, who have very little knowledge of Excel at the moment and would rather not confuse them any futher.
Does anyone how i could permanently delete any reference that this form ever had a macro in it?
Cheers
I have recently been redesigning some forms for my accounts system and got very frustrated with having to use the 'Merge & Centre' button every few seconds, so found a way, to bind a key to a Macro that did it for me. But now i no longer need the macro and have deleted it, but every time I open the form I now get an 'Enable / Disable' pop-up.
The only way i can find to stop the pop-up is to set the Macro Security to low, but i would rather not do this -
1) For security reasons
2) The form will not be used by me, and was designed to be as simple as possible to use by our Rwandan staff, who have very little knowledge of Excel at the moment and would rather not confuse them any futher.
Does anyone how i could permanently delete any reference that this form ever had a macro in it?
Cheers