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

Macro Security--Does it restore the VBA project?
 

Cross-post is when you post one message with several news groups in the
"newsgroups" dialog.

microsoft.public.worksheet.functions,microsoft.pub lic.excel,microsoft.public.excel.misc

Note the comma between each group.

All the regulars monitor all the Excel news groups, so if the topic is Excel, no
need to post to more than one group.

Although I should amend that..........the programming group is strictly for VBA
so if you have a VBA question you would be best posting to that group.

Multi-posting is when you post similar messages singly to each group.

Those of us who use real newsreaders can pick up the cross-posts and flag them.

No way to flag multi-posts.


Gord Dibben MS Excel MVP

On Wed, 14 Mar 2007 14:55:08 -0700, childofthe1980s
wrote:

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?

Macro Security--Does it restore the VBA project?
 

And it sounds like your workbook is corrupted.

Sometimes opening and saving in a different version of excel can help (sometimes
not).

If it is a corrupted workbook, you may want to try openoffice. Lots of people
have said that it's recovered workbooks (include the project) that excel
couldn't.

(http://www.openoffice.org, a 60-65 meg download or a CD)

If the file is really important, there are commercial recovery services. I've
never used it, but you might want to check into:
http://www.officerecovery.com

childofthe1980s wrote:

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

--

Dave Peterson