Thread: Macro freeze up
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RHall RHall is offline
external usenet poster
 
Posts: 12
Default 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