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"?

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 wrote:

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

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.

"Dave Peterson" wrote:

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 wrote:

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

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

On Thu, 5 Mar 2009 14:03:01 -0800, hcr62
wrote:


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.

"Dave Peterson" wrote:

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 wrote:

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

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" wrote:

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

On Thu, 5 Mar 2009 14:03:01 -0800, hcr62
wrote:


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.

"Dave Peterson" wrote:

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 wrote:

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

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


On Sun, 8 Mar 2009 10:52:04 -0700, hcr62
wrote:

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" wrote:

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

On Thu, 5 Mar 2009 14:03:01 -0800, hcr62
wrote:


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.

"Dave Peterson" wrote:

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 wrote:

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