$$Excel-Macros$$ Re: Annoying popup for with Cancel button when opening workbooks

2010-10-23 Thread Riaz Hassan
buddy, i'm mean the file i send u is excel 2003 (i.e .xls). but still you can use it and u can convert to .xlsx as well On Oct 22, 6:57 pm, simonl wrote: > So do you suggest I un-install and re-install Office? > > On 22 Oct, 15:20, Ashish Jain wrote: > > > > > Hi Simon, > > > Application.Dis

$$Excel-Macros$$ Re: VBA PASSWARD REGARDEING

2010-10-21 Thread Riaz Hassan
Private Sub Workbook_Open() Dim pw pw = InputBox("Please Enter The Password", "PassWord") If UCase(pw) <> UCase(Trim("abc")) Then Me.Close (savechanges = no) End If End Sub On Oct 21, 8:56 am, Jai wrote: > Dear Group member, > > please provide the VBA Code to protect the exc