I have a an excel spreadsheet which only has cols A - E that I want visible to the user. Cols G - L are used for off-screen calculations and reporting etc. So I have reduced the window size of the spreadsheet to only show cols A - E and applied Workbook and sheet protection with a password with all options ticked. This locks the window size ok and stops the user from viewing formulas etc.
However .. if they scroll right with the cursor .. the spreadsheet moves to the right to show my reporting colums ( which I need to leave un-hidden cos I use them as a print Preview )
How do I make the cursor movement restrict to columns A - E only ?
Thanks
However .. if they scroll right with the cursor .. the spreadsheet moves to the right to show my reporting colums ( which I need to leave un-hidden cos I use them as a print Preview )
How do I make the cursor movement restrict to columns A - E only ?
Thanks