CHECK IT ONCE THROUGH ATTATCHMENT
command Visible Buttons:-,
1.Open the document for which you want to record a macro.
2.Click the Record Macro icon or choose the menu command Tools - Macros - 
Record Macro.
You see the small Recording dialog with just one button called Stop Recording.
3.Perform the actions you want to be recorded in the document.
Press the Escape key to deselect an object, as the macro recorder currently 
does not record this action by mouse click.
4.Click Stop Recording.
The Macro dialog appears, in which you can save and run the macro.
If you want to abort the recording without saving a macro, click the Close 
button of the Recording dialog.
5.To save the macro, first select the object where you want the macro to be 
saved in the Save macro in list box.
6.If you want the macro to be saved into a new library or module, click the New 
Library or New Module button and enter a name for the library or module.
7.Enter a name for the new macro in the Macro name text box.
8.Click Save.
9.using this procedure, i recorded using hide option,hiding some cells of sheet 
and save it.
10.Then,Running the macro(saved one),it displays not hided elemnts(not 
reproduce what i did it using macro).Sometimes,it displays 'some cells hiding'.
11.Suppose,By default i directely click the 'runningmacro' option it 
displays "please install the JRE ENVIRONMENT"
12.Then i press it 11 times the running macro item box displayed