View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default VB prompts for Password when 'View Code' selected, r-click on tab

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