I need to assign a macro to a button. Problem is I can't make a button.
All ther "Forms" are greyed out so I can't select them.
THis is Office 2003 I am working with BTW.
After I get the button made I need to copy this workbook over the network to a different machine. I do not want the Error/Warning box to appear that say Enable/Disable Macros, etc. Isn't there someway to tell the pc to accept any excel files that contain macros that I create without prompting?
I know there's a way to set the security level to Low but I would rather not do that. I see where it lists Trusted Publishers but I don't know how to add myself to it?
THanks
All ther "Forms" are greyed out so I can't select them.
THis is Office 2003 I am working with BTW.
After I get the button made I need to copy this workbook over the network to a different machine. I do not want the Error/Warning box to appear that say Enable/Disable Macros, etc. Isn't there someway to tell the pc to accept any excel files that contain macros that I create without prompting?
I know there's a way to set the security level to Low but I would rather not do that. I see where it lists Trusted Publishers but I don't know how to add myself to it?
THanks