VB prompts for Password when 'View Code' selected, r-click on tab

[hcr62]

I use Excel 2003, and I am referring to web page
http://www.contextures.com/xlVideos02.html#MacroWarn. In following the
instructions (Stop the Macro Warning After Macros Deleted) to remove a
'false' warning that Macros are part of my spreadsheet, I right-click on the
worksheet tab and select 'View Code'.

At this point, instead of being able to view related workbooks, a Visual
Basic window opens and I get a request to 'Enter Password'. I have no idea
what password to enter, I have never seen this procedure nor have I ever used
Visual Basic. However, the Visual Basic application seems to be present, and
it is that application that requests a password. What can I do to continue my
edit to remove modules (that contain false macros), as per the video "Remove
Macro Warning in Excel"?

 

[Dave Peterson]

It sounds like you may be looking at the wrong project.

What workbook/project did you select?

But if it's the correct workbook project, did you get the workbook from someone
else? If yes, then go back to that developer to resolve the problem.

 

[hcr62]

I don't know about a 'wrong project'. This is a spreadsheet that I use to
invoice customers. I copied it (to create a test version) and I get the
Disable/Enable macros warning when I open it. (Occurs in my invoice as well
as the test version.

The point is, in following the instructions to 'View Code', I cannot get
past the VB Password requirement. Where is this password? What created it?
Was it VB - ? To my knowledge, there is no password associated with the
spreadsheet, but how do I get past this point to where I can review the
related workbooks and modules?

Thanks for giving your time and consideration to my question.

 

[Gord Dibben]

The password on VBA project is to prevent users from accessing and seeing
the code.

Open a new clean workbook.

Alt + F11 to go to VBE.

Right-click on the workbook and select "Properties"

You will see the dialog for locking a project.

It would appear this has been done with your problem workbook.

Someone has "locked the project for viewing".

Maybe time to copy the worksheets from the workbook into a new clean
workbook.


Gord Dibben MS Excel MVP

 

[hcr62]

I understand now about how the password can be set, by someone, to prevent
access to the worksheet. Of course, I don't have a clue as to what the
password might be, but the only inconvenience is the warning to 'Enable or
Disable Macros' every time I open the spreadsheet.

Following instructions, I was attempting to remove the module that causes
the warning to appear. Since I do NOT want to upset the functionality of the
Invoice Spreadsheet, I am content to leave things as they are. I just wish I
knew why I have to live with the warning, since I always say 'Enable' and
wish this could be defaulted (or the warning eliminated).

Thanks, all, for your answers. Sorry I'm so dense.

 

[Gord Dibben]

Do you have any idea if the workbook is using some code from the VBAProject?

If not, just select the sheets and copy to a new workbook.

Might not disrupt the functionality at all.

Wouldn't hurt to try.

Elsewise............................

If just for use on your own computer, create a digital signature using the
Office SelfCert tool.

Sign the workbook, which you can do even if the project is locked for
viewing.

That will stop the enable.disable warning.

See Excel help on "digital certificates"

Or see this posting under my name for creating and installing a selfcert
signature to a workbook.

http://tinyurl.com/cbkohu



Gord

I understand now about how the password can be set, by someone, to prevent
access to the worksheet. Of course, I don't have a clue as to what the
password might be, but the only inconvenience is the warning to 'Enable or
Disable Macros' every time I open the spreadsheet.

Following instructions, I was attempting to remove the module that causes
the warning to appear. Since I do NOT want to upset the functionality of the
Invoice Spreadsheet, I am content to leave things as they are. I just wish I
knew why I have to live with the warning, since I always say 'Enable' and
wish this could be defaulted (or the warning eliminated).

Thanks, all, for your answers. Sorry I'm so dense.

 

[hcr62]

I will follow the instructions in your link, Gord, to see if I can
establish a selfcert, since I believe I already tried copying the workbook.
Or is that different from selecting the cells from one sheet and placing them
in a new sheet in a new workbook? I'm kind of hazy on all the terminology.
What I did was copy invoice.xls to test.xls and the macro problem followed.
Are you saying I need to copy just the worksheet? There is a name for the
worksheet - 'Invoice'. On the worksheet, there is a button - 'Customize'.
When I click the button, a new tab appears - 'Customize Your Invoice'. This
leads me to believe there IS a VBA behind the Invoice, and so the selfcert is
perhaps the only way I will avoid the message. Thank you!

 

[hcr62]

Ooops! I didn't have any problem, until I got to the part where I save the
spreadsheet and exit (so I could return and see NO disable/enable message). I
created the selfcert no problem, and seemed to attach it to the VBE screen.
(In workbook, 'Tools/Macro/Visual Basic Editor/Tools/Digital
Signature/Choose/OK/OK') However, at workbook exit time ('Close VBE/Close
Workbook/Save Changes/OK'), I got this warning notice:
"This workbook contains Excel 4.0 macros. Workbooks containing these macros
cannot be signed. Remove the Excel 4.0 macro sheets, and then try the signing
operation again." At this point, the workbook closes and the selfcert is not
applied.

So - there ARE macros here, and it seems I MUST live with the warning
message to either enable or disable them. Unless I'm missing something?