View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
childofthe1980s childofthe1980s is offline
external usenet poster
 
Posts: 122
Default Macro Security--Does it restore the VBA project?

Hello:

In Excel 2002, there are the Low, Medium, and High security features. On
the other tab are the Trusted Sources checkbox.

Let's say that you have an Excel spreadsheet with macros. And, let's say
that you reinstall Excel including reinstalling VBA in the shared components.

If you afterward get the error message the error message: "This workbook
has lost its VBA project, ActiveX controls and any other
programmability-related features", will changing the Macro security setting
in Excel from Low to High "fix" this issue and allow you to see and use your
macros that you had?

I'm just trying to see how to eliminate this error message and see if the
macros are truly "gone".

Also, could someone let me know please how to cross-post on this Newsgroup.
I offended some users earlier today by posting a similar question on several
newsgroups and someone suggested that I cross-post instead of multi-post.
How do I cross-post?

My apologies to anyone that I offended. I'm just trying to help others and
learn some things in the process.

Thanks!

childofthe1980s