Changing Macro Security
Installing an Add-in
Using Keyboard shortcuts
Installing an Add-in
Using Keyboard shortcuts
Transcript of the video:
Learn Excel form MrExcel podcast episode 2137.
Changing Macros Security.
When I'm working with someone and they've never run Macros before I'm on the phone with and I'm trying to tell them how to change Macro security it is a hassle to go into File, Options, Trust Center, Trust Center Settings and then Macro settings and then Disable Macros without notification I say look just do this Alt T for Tim, M for Mary, S for Sam and it gets them right to that dialog box.
That used to be Alt+T would open the Tools menu in Excel 2003, M would be Macro, S would be security.
Definitely, a faster way to go and then related to that one if we need to enable an Add-in, well, do you have solver, add solver available that File, Options, Add-in's go to the lower left-hand corner choose regular Add-in's, click go and then you get finally get to this dialog box.
Just Alt+T, I so, I just say look press alt T for Tim, I for Irene and click check the box for solver.
Two cases where the old, old keyboard shortcuts are dramatically faster than the new way to get there all right.
Oh hey, I wanna thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
Changing Macros Security.
When I'm working with someone and they've never run Macros before I'm on the phone with and I'm trying to tell them how to change Macro security it is a hassle to go into File, Options, Trust Center, Trust Center Settings and then Macro settings and then Disable Macros without notification I say look just do this Alt T for Tim, M for Mary, S for Sam and it gets them right to that dialog box.
That used to be Alt+T would open the Tools menu in Excel 2003, M would be Macro, S would be security.
Definitely, a faster way to go and then related to that one if we need to enable an Add-in, well, do you have solver, add solver available that File, Options, Add-in's go to the lower left-hand corner choose regular Add-in's, click go and then you get finally get to this dialog box.
Just Alt+T, I so, I just say look press alt T for Tim, I for Irene and click check the box for solver.
Two cases where the old, old keyboard shortcuts are dramatically faster than the new way to get there all right.
Oh hey, I wanna thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
