Hidden Code In WorkBook

[excelmetotheground]

Hi and thanks to anyone in advance who can solve my problem =]

I have been sent an excel spreadsheet that calculates income tax (see attachment). However I am unable to find the code/formulas that processes and calculates the tax reductions. I can view the formulas, however they do not show how the reduction is calculated.

If anyone can show me where the code/ formulas have been hidden it would be greatly appreciated.

Kind regards, RSO

[shg]

Please take a few minutes to read the Forum Rules about thread titles, and then edit yours to make it descriptive of your problem.

There's a VeryHidden sheet, TaxBackup2008R123. To see it,

• Do Alt+F11 to open the VBE,
• Press F4 to open the Properties window
• Select Sheet2 in the Project Explorer window
• In the Properties window, scroll down to the Visible property and use the drop-down to change it to xlSheetVisible.

[excelmetotheground]

Many thanks. It works great. Thanks for taking the time to help solve this problem =]

[shg]

Would you please mark the thread as Solved?

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the words No prefix; change to Solved
Click Save