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

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