user not allowed to change sheet

[Sonyk]

Hello again

I want to make a book complety impossible to change from sheet to sheet (that can only be done by buttons that redirect the user to that specific sheet)

Is there a way to do this?

[Paul]

Hi Sonyk,

The following macro does what I think you're after. Start by hiding all of the worksheets in the workbook (except one, of course, since Excel requires one worksheet as visible). Add this code to your ThisWorkbook module (in the VB Editor window) and then on the Review ribbon, Protect the Workbook. The code below uses a workbook protection password of "aaa".

The code, which could be attached to a toolbar button (rather than a button on each sheet in the workbook), simply asks the user which sheet they want to go to - and it provides a list of all of the worksheets available in the workbook. The user just needs to type the name of the worksheet in the space provided and press OK. The macro will unprotect the workbook, hide the active sheet, open the new sheet, then re-protect the workbook.

Hope that helps!

Please Login or Register  to view this content.