Office 97 & Win2k/XP

M

mark

Dear All

I have posted this question before but does anyone know of a workaround to
access VBA running the above combination on a PC? Alt+F11 doesn't work and
of course trying to load any Excel sheet with Macros returns a NO PERMISSION
dialogue.
I'm not going to moan about our IT Manager because he is extremely busy with
other IT Projects and he states that he has been trained in hardware and
programming not software. He won't upgrade the installation on the PC
because he claims that no one will use the features in the newer version of
Excel (which is stopping my program running on one of the PC's in the
warehouse - userforms and the such can't be accessed!)

Any help gratefully received

Mark
 
B

BrianB

I have Excel 97 and 2000 running happily on both platforms. Somehow your
Windows system is set up to block this. Perhaps the security level is
set too high.
 
P

Peg

I agree. It sounds like the macro security is High, which
automatically disables macros.
 
M

mark

Thanks for the replies but have tried that one already!

Just simulated high macro protection on my computer and the workbook loaded
normaly but with macros disabled. (Alt+F11) opened up the IDE. When I try
to load the workbook at work it won't even load the workbook and Alt+F11
won't open the IDE even on a blank new worksheet. Hang on it's a networked
computer would the Administrator be able to stop Office writing a new
line/file to the registery and therefore stop Office macros running?

Any ideas?

Mark
 
Top