I once had a spreadsheet I could not modify- turns out for that sheet the
security settings were set to very high- so I was unable to unprotect and
unlock the form in design mode. once I changed the security settings, I saw
that the form was locked with either the VB toolbox or forms .... I unlocked
it and was able to unprotect it. (all my format tools such as row height,
hide, unhide were ghosted out.

Is your row height, unhide command ghosted out, or is it active and
available and it just will not respond??

"haibebu2" wrote in message
...
I did hide some of the rows in my excel file. But then I could not unhide
them ? What is the reason for this behavior ?