I created a macro with hidden sheets, etc. The basic premise is that there are nine people and each person can only see their worksheet based on their entered password. After creation and testing on my computer, I sent it out. For some people it works fine, for others, they receive the a runtime error code 2004, "this operation requires the merged cells to be identically sized".
Any reason for this? I created the macro in Excel 2007 but saved it as Excel 97-2003.
Thanks in advance. I apolgize if this information is out there somewhere, I did some searches but couldn't find anything.
Any reason for this? I created the macro in Excel 2007 but saved it as Excel 97-2003.
Thanks in advance. I apolgize if this information is out there somewhere, I did some searches but couldn't find anything.