ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA Error Message (https://www.excelbanter.com/excel-programming/311316-vba-error-message.html)

dave

VBA Error Message
 
I asked this question a couple of days ago and got no
response, so thought I would try one more time. So here
goes...

I have a couple of files that a friend of mine programmed
using vba. I do not know anything about programming, but
when I try to open the excel files, I get an error message
that says, "Microsoft Visual Basic - Error accessing the
system registry". When I click ok, the error message goes
away, but the file will not open. Can someone please tell
me how I can get rid of this problem? Thanks.

Jean-Yves[_2_]

VBA Error Message
 
Hi Dave,

If you don't know anything about VBA, ask somebody else.
You could change , just in excel with a new workbook, to change the macro
security to medium.
Then when you open the file created by your frien, a popup will ask if you
want to enable or disable macro.
Select no- macro disabled.
This should allow you to open the file.
It is not really good that this files contains macros are playing with your
registry settings. In fact it could even be harmfull to your computer as it
could be a virus.
Regards
JY
"Dave" wrote in message
...
I asked this question a couple of days ago and got no
response, so thought I would try one more time. So here
goes...

I have a couple of files that a friend of mine programmed
using vba. I do not know anything about programming, but
when I try to open the excel files, I get an error message
that says, "Microsoft Visual Basic - Error accessing the
system registry". When I click ok, the error message goes
away, but the file will not open. Can someone please tell
me how I can get rid of this problem? Thanks.




Tom Ogilvy

VBA Error Message
 
Try holding down the shift key when you open the file.

If it opens, then go in and remove all the macros and save it as a different
name.

--
Regards,
Tom Ogilvy

"Dave" wrote in message
...
I asked this question a couple of days ago and got no
response, so thought I would try one more time. So here
goes...

I have a couple of files that a friend of mine programmed
using vba. I do not know anything about programming, but
when I try to open the excel files, I get an error message
that says, "Microsoft Visual Basic - Error accessing the
system registry". When I click ok, the error message goes
away, but the file will not open. Can someone please tell
me how I can get rid of this problem? Thanks.





All times are GMT +1. The time now is 05:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com