Bajrang Sharma

Sub UnProtectAll()          Dim wSheet           As Worksheet     Dim Pwd              As String         Pwd = InputBox("Enter your password to unprotect all worksheets", "Password Input")     On Error Resume Next     For Each wSheet In Worksheets         wSheet.Unprotect Password:=Pwd     Next wSheet     If Err <> 0 Then         MsgBox "You have entered an incorect password. All worksheets could not " & _         "be unprotected.", vbCritical, "Incorect Password"     End If     On Error GoTo 0      End Sub

TDS rates for the FY 2013-14 Sl. No. Section Of Act Nature of Payment in brief Cut Off Amount Rate % HUF/IND Others 1 192 Salaries Average Rate 2 193 Interest on debentures 5000 10 10 3 194 Deemed dividend - 10 10 4 194A Interest other than Int on securities (by Bank) 10000 10 10 4A 194A Interest other than Int. on securities (By others) 5000 10 10 5 194B Lottery / Cross Word Puzzle 10000 30 30 6 194BB Winnings from Horse Race 5000 30 30 7 194C(1) Contracts 30000 1 2 8 194C(2) Sub-contracts/ Advertisements 30000 1 2 9 194D Insurance Commission 20000 10 10 10 194EE Payments out of deposits under NSS 2500 20 - 11 194F Repurchase of units by MF/UTI 1

Advance Tax & Income Tax Calculator AY 2014-15 (FY 2013-14) for Companies, Firms, Local Authorities and Cooperative Societies Advance Tax No advance tax (also written shortly as A. Tax or Adv. Tax) is payable if the total income tax liability after reducing the tax deducted at source is less than Rs. 10000/-. If Advance Tax is not paid in full for installments falling due on 15th June (for Corporates only), 15th September and 15th December, interest at the rate of 1% on the short amount for 3 months is to be payable. If Advance Tax is not paid in full for installments falling due on 15th March, interest at the rate of 1% on the short amount for 1 month is to be paid. If the payment of the last instalment in March is delayed by even a day, interest is to be paid on the entire instalment amount. If you do not pay advance tax at all or if the aggregate paid by March 31 is less than 90 per cent of the total tax payable, you will have to pay an interest of 1 per cent

1. What is e-TDS Return? e-TDS return is a TDS return prepared in form No.24,26 or 27 in electronic media as per prescribed data structure in either a floppy or a CD ROM. The floppy or CD ROM prepared should be accompanied by a signed verification in Form No.27A. 2. Who is required to file e-TDS return? As per Section 206 of Income Tax Act all corporate and government deductors are compulsorily required to file their TDS return on electronic media (i.e. e-TDS returns). However, for other Deductors, filing of e-TDS return is optional. 3. Under what provision the e-TDS return should be fil

Odisha VAT (Value Added Tax) is a tax implimented by the Odisha Sales Tax department in place of Sales Tax in the Year 2004. This tax (VAT) is applicable on sale of scheduled goods and the rate differs from 0%, 1%, 5% or 13.5% depending on the item and mentioned in the schedules of Odisha VAT. A dealer has to charge VAT on sale of goods and pay the same to the department after taking the benefit of input VAT (vat on purchases). For eg. A dealer purchased goods for Rs. 100/- and pays Rs. 5 as input VAT and sells the same for Rs. 200 and collect Rs. 10/- as output VAT then he have to pay Rs. 5/- to the dept. (i.e. Output VAT - Input VAT = VAT Payable) Now a days the dept has made is mandatory to make the payment online and file the returns online too. A dealer has to file the return through form (VAT-201) online.

What is excise duty? An excise or excise tax (sometimes called an excise duty) is a type of tax charged on goods produced within the country (as opposed to customs duties, charged on goods from outside the country). It is a tax on the production or sale of a good. This tax is now known as the Central Value Added Tax (CENVAT). The different types of Excise duty are as follows: - Basic Excise Duty (BED) : This is the duty charged under section 3 of the Central Excises and Salt Act, 1944 on all excisable goods other than salt which are produced or manufactured in India.  Basic Excise Duty [also known as Central Value Added Tax (CENVAT)] is levied at the rates specified in Central Excise Tariff Act. Special Excise Duty (SED) : As per the Section 37 of the Finance Act, 1978 Special excise Duty was attracted on all excisable goods on which there is a levy of Basic excise Duty under the Central Excises and Salt Act,1944. Special Excise Duty is levied at the rates s

Activate & De-activate Ribbon, Status Bar and Formula Bar in Excel  These codes can hide the ribbon, formula bar, status bar when you open a excel file and the second code will automatically restore all of them when you close the file. Private Sub Workbook_Activate()     Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"     Application.DisplayFormulaBar = False     Application.DisplayStatusBar = Not Application.DisplayStatusBar     ActiveWindow.DisplayWorkbookTabs = False End Sub Private Sub Workbook_Deactivate()     Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"     Application.DisplayFormulaBar = True     Application.DisplayStatusBar = True     ActiveWindow.DisplayWorkbookTabs = True End Sub This VBA Code will help you to disable the SaveAs function in Excel   Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)     If SaveAsUI = True Then         MsgB