Random Cells Reformat on other computers

T

Thij_rahya

Hi, I have a document that I created in Excel 2003. It's set to read only, so
I know that no one has changed it. It works just find on my computer. When
other people on my team use the document unpredictable ranges of cells
change. This change appears to be random. On some computers random cells will
change to black or blue backgrounds, on others text will format to match the
background color. I would very much like it to stop.

What is of peculiar interest is the fact that the document still works fine,
and never manifests these issues on my own computer.

Our help desk insists that I created the problem when I created the
document, and refuses to help any futher, so, before I get forceful with them
I thought I'd bring it to the internets, because it's so much more helpful :)

Thanks.
 
T

Thij_rahya

We have created a macro in this workbook, and it happens to effect all other
workbooks that are open, not just the workbook in question.

But only on other people's computers.
 
P

p45cal

Thij_rahya;483845 said:
We have created a macro in this workbook, and it happens to effect al
other
workbooks that are open, not just the workbook in question.

But only on other people's computers.


Code Cage Forums
(http://www.thecodecage.com/forumz/showthread.php?t=133417)
Click to expand...

Then it may be to do with macro security levels, some people's may b
set to low in which case macros will automatically be allowed to ru
without asking. If set to high and the workbook is non-trusted then th
macros won't run. If set to medium and non-trusted, they will be aske
if they want to allow macros to run.
If keyboard shortcuts have been assigned to some macros, and the
overwrite the default shortcuts, users might be trying to use a defaul
shortcut such as Ctrl+c to copy, but it's running a macro instead?

What macros are they? What do they do
 
T

Thij_rahya

The Macros Are set for Ctrl+e and Ctrl+r. The Macros basically run through a
series of mouse clicks, filtering sheets, deleting sheets, and renaming
sheets.

What is odd is the Macros run just fine, and the result is just fine as
well. When people go to other Excel documents they have open, or, when the
use the workbook for reference, without using the macros, then the formatting
problems start.
 
Top