Macro freeze up
I can run a macro from the VBA Editor but when I run it from the Ctrl key
set for it, it stops after selecting from a file that it has opened. This
happens when I run macros on two different workbooks and different macros.
The sheet is open and on the screen. I can't step through the macro since it
runs fine when in the editor.
I''ve tried it with the sheet protection on and off. I'm stuck. I can't
turn the system over to the user if they can't use the CTRL+key to run it.
Any suggestions would be appreciated.
P.S. My HPageBreak doesn't work either. I used the code from this site.
The page break also doen't work from Excel-Insert-Page Break either.
I'm running Excel 2002 with no upgrades or fixes.
--
none
|