Gingit wrote:
I have a spreadsheet with hidden rows. When I open the file it unhide
all rows of one tab. When I go and unhide the rows and open the file a
second time this happens again and the rows unhide. It does not happen to my
co-workers. It is probably a way that my Excel is set up. Not sure if it
has macros associated with is.

Any ideas how to keep it hidden?

Thanks,

Hi Gingit,

Yeah it sounds like you may have an unmerge macro set to trigger when
the workbook it is opened, as if the cells are hidden before the
workbbok is saved, they will normally be hidden when the workbook is
opened again. Firstly do you know much about macros and are there any
currently on the workbook that must remain?

I'm not sure of your skill level so please excuse me if the directions
seem to simple. To check if there are macros in the workbook (I'm
presuming you have Excel 2000 or above) click Tools Macro Visual
Basic Editor. when the new window opens (vba) look at the left hand
side of the screen for the 'Project Explorer' if it's not visible click
on the Project Explorer icon and it will open.

Macros can be on the spreadsheet or available to the entire workbook.
double click on each spreadsheet in the Project Explorer until you see
some code appear in the main window, the code may also be in a module
so if you can't find macros on the sheets try the modules.

If you come across a macro the code your looking for is .MergeCells =
False, change it to .MergeCells = True, save it, close the workbook,
re-open and it should now be ok.

NB: If there is a macro currently in use on the workbook your using
which contains the unmerge code then check first if it is necessary,
you may need to leave it as is because this is most likely necessary
for the macro to run, or if your company is big enough to enjoy an
IS/IT dept. get them to do it!

Let me know if you need more help