Unable to "unhide sheet"

[datadan]

When I go to format/sheet all options are gray. How can I reset these values?

Thanks,

 

[rmikesmith]

datadan,

Have you checked Worksheet and Workbook Protection?

Any additional info about the affected workbook, version of Excel, etc.??

Regards,
M. Smith

 

[SunlitMik]

Select the Sheet Tab before the sheet that's hidden,hold down the control key and select the sheet after the hidden sheet (this might be two tabs in a row). Then right-mouse and unhide sheet. Otherwise you will need to check protections as previously stated.

 

[datadan]

I guess I protected the workbook instead of the sheet. Thanks....

In a macro this bit of code protects the workbook. How do I set the password?
ActiveWorkbook.Protect Structure:=True, Windows:=False

ActiveWorkbook.Protect "password" Structure:=True,Windows:=False

Thanks,

 

[datadan]

Nevermind, I figured it out. Thanks for the help guys!