Blocking acess to some sheets

[dvstruco]

Hello people

I have a workbook with some sheets. The user can acess some sheets, but other sheets are "secret". There's no buttons to acess these sheets, but if the user uses the shortcuts CTRL+PGDOWN or CTRL+PGUP is possible.

I want to block the acess to some sheets. How could I do that?

 

[JoeMo]

Hello people

I have a workbook with some sheets. The user can acess some sheets, but other sheets are "secret". There's no buttons to acess these sheets, but if the user uses the shortcuts CTRL+PGDOWN or CTRL+PGUP is possible.

I want to block the acess to some sheets. How could I do that?

Make those sheets xlVeryHidden: Right-click sheet tab and choose View Code> on the VBE menu choose View>Properties. Scroll down the Properties list to Visible and in the adjacent drop down choose xlVeryHidden.

 

[dvstruco]

Make those sheets xlVeryHidden: Right-click sheet tab and choose View Code> on the VBE menu choose View>Properties. Scroll down the Properties list to Visible and in the adjacent drop down choose xlVeryHidden.

Thank you. Works.