Cannot edit or remove macros

  • Thread starter Matthew Gardner
  • Start date
M

Matthew Gardner

Hi everyone.

I am working with spreadsheets that I have inherited in
my office. I am a relative novice when it comes to
macros, but have already tried the following solutions:

Through the tools menu, I have tried to modify, delete,
remove, edit, etc the various macros, and cannot modify
them in any way. Their reference is invalid and they are
password protected.

I have tried to find the macros in the VBA editor as
well, and cannot get into several areas there that are
also password protected.

I tried to replicate the individual sheets that contain
the macros, and they stay in the workbook, no matter how
I recreate things.

This is a fairly complicated financial model, and
starting from scratch is not an option.

Thank you for your help in advance.
Matt
 
M

Myrna Larson

I guess your only option, then, is to get the password. There are "crackers"
available if the person who protected the code isn't available. Go to Google
and look for Excel password cracker.
 
E

Earl Kiosterud

Matthew,

It sounds as though the macros are locked from viewing. In the VBE, if you
do Tools - VBA Project Properties, and are prompted for a password, it is.
Unless you get a password cracker, you'll not be able to see them or mess
with them.
 
Top