Try a test.

Turn off that option. Create a workbook with a simple macro. Save the workbook
and close and reopen excel and that workbook.

Your macro will run ok--well, unless your simple macro tries to do something
that accesses a project.

And I'm guessing that you have a shortcut key (not built into excel) that would
open the VBE. And that stopped you from getting to the VBE to create/edit
macros.

I'm not sure why you're writing about downloaded or imported workbooks. The
workbooks could contain macros that you developed and saved.


JLGWhiz wrote:

Hi Dave, I may not have chosen my words very well it the first posting.
Since I have always had my access to VBA turned on, I have not thought much
about what life would be like without it. But, I do remember when I first
fired up my xl2003, it was not on and I could not open the VBE until I
checked the box. However, it makes sense the macros will run without the box
being checked, but the only way I can think of that they would be available
to run is from a downloaded or imported workbook that already contained the
macro. If that is not the case, I would appreciate some enlightenment.

"Dave Peterson" wrote:

That's not right.

Trust to the VBA Project allows the user to run programs that would
add/delete/change/read code. It's got nothing to do with the user running
macros.

JLGWhiz wrote:

If they want to run macros in VBA then they have to check the box. If they
never intend to use VBA then they don't need to check the box. Pro they can
use it. Con they can't.

"Barb Reinhardt" wrote:

What are the Pros/Cons of having users select Trust the VBA Project?

Thanks,
Barb Reinhardt


--

Dave Peterson


--

Dave Peterson

Well, that blew my whole concept of what that check box controlled. Thanks
for the wake up.

"Dave Peterson" wrote:

Try a test.

Turn off that option. Create a workbook with a simple macro. Save the workbook
and close and reopen excel and that workbook.

Your macro will run ok--well, unless your simple macro tries to do something
that accesses a project.

And I'm guessing that you have a shortcut key (not built into excel) that would
open the VBE. And that stopped you from getting to the VBE to create/edit
macros.

I'm not sure why you're writing about downloaded or imported workbooks. The
workbooks could contain macros that you developed and saved.


JLGWhiz wrote:

Hi Dave, I may not have chosen my words very well it the first posting.
Since I have always had my access to VBA turned on, I have not thought much
about what life would be like without it. But, I do remember when I first
fired up my xl2003, it was not on and I could not open the VBE until I
checked the box. However, it makes sense the macros will run without the box
being checked, but the only way I can think of that they would be available
to run is from a downloaded or imported workbook that already contained the
macro. If that is not the case, I would appreciate some enlightenment.

"Dave Peterson" wrote:

That's not right.

Trust to the VBA Project allows the user to run programs that would
add/delete/change/read code. It's got nothing to do with the user running
macros.

JLGWhiz wrote:

If they want to run macros in VBA then they have to check the box. If they
never intend to use VBA then they don't need to check the box. Pro they can
use it. Con they can't.

"Barb Reinhardt" wrote:

What are the Pros/Cons of having users select Trust the VBA Project?

Thanks,
Barb Reinhardt


--

Dave Peterson


--

Dave Peterson