I want to record a macro but when I select 'record macro' and name the Macro and click OK- I am asked for a password. I have never used Macros before. Where has the password function come from and how do I overcome it?
Passwords are normally saved in a template called normal.dot. If you are working in a company that has got a central normal.dot that is write protected, then you can't save your own macros into it.
The solution is to start an empty file and save it as a template and then store your macros in that file.
Otherwise find out who created the file you are using, when you get that message and ask him or her why the code is password protected and how to deal with this.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.