Worksheet Protected

Most of the worksheets provided in Share Trade Tracker have Worksheet Protection enabled. This is in place to ensure that formulas and formats are retained within the workbook and that it continues to present your trading information with the intended results. If you try and modify information directly on a worksheet you will see the following warning message.

Then if you try and UnProtect a worksheet you will see the following prompt. You do not need this password as Share Trade Tracker has been developed with automated formulas and formats that should not be modified by the user.

The following Share Tracker worksheets are entirely protected and all updates to these worksheets is via the functions available on the ribbon (eg Modify Trade)

• Buy Trades

• Open Positions

• Sold Trades

• Dashboard

• Charts

• ReportFY

• ReportDR

The other Share Trade Tracker worksheets do allow some direct entry on the worksheets. But those updates are limited only to certain areas of the worksheet. For example on the Dividends worksheet you can select which Portfolio a dividend is applied for you can also change the Ex-Dividend Date and Dividend if required.

• Dividends

• CashAccounts

• Interest

• TradingDiary

• VAMI

Create your own UnProtected Worksheet

If you trading analysis needs other functions and calculations then you can create your own worksheets within Share Trade Tracker. You can then link any values in the protected worksheets to those created worksheets to enable other calculations.