Disable Unhide Control

[Vicky9063]

Hi,
How do i disable the Format/Sheet/Unhide control function in excel so that the user does not interfere with my macros??
Cheers
V

 

[Ashwini Ramesh]

If, after hiding a worksheet, you use Tools>Protection>Protect Workbook, the hidden worksheets cannot be unhidden via Format>Sheet>Unhide - you first have to Unprotect Workbook in order to show them. If you add a password to Protect Workbooks, this makes it even more secure.

If you have macros that need to show or use the hidden worksheets, you can incorporate an Unprotect Workbook line at the beginning of the macro and Protect Workbook line at the end.

Hello sir,
i dont find tools option in my Excel 2007 , could you pls help me to find where it will be ? or any other way to disable unhide control ?

 

[avi10000]

I am using Excel 2010.

This is does not appear to work.

I put the command in Private Sub Workbook_Open().

I also put it in a 'temp' subroutine and I ran it while teh workbook was already open, and it still did not work.

Hi Vicky,

This is a bit long, but here goes...

Application.CommandBars("Worksheet Menu Bar").Controls("F&ormat").Controls("S&heet").Controls("&Unhide...").Enabled = False

Whew!

Keep Excelling.

Damon