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

Macro freeze up
 

If you have Application.screenupdating = false in your macro, try removing
it. One of the subtle differences between stepping through a macro and
running it is that screenupdating is always on when you step through it. If
the macro is doing charting work, I have found that updating must be on or
else some charting commands will not work.

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"RHall" .(donotspam) wrote in message
...

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

Macro freeze up
 

Workbooks.Open Filename:="Jobs Data.xls"
This line executes but the next line which selects a sheet doesn't
Screen updating is True
--
none


"Bob Flanagan" wrote:

If you have Application.screenupdating = false in your macro, try removing
it. One of the subtle differences between stepping through a macro and
running it is that screenupdating is always on when you step through it. If
the macro is doing charting work, I have found that updating must be on or
else some charting commands will not work.

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"RHall" .(donotspam) wrote in message
...

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

Macro freeze up
 

Without being able to see the code, anything offered is strictly a guess. If
you want real assistance, please post the code that gives the problem.
Simply copy it and paste it into the newsgroup reply pane.

"RHall" wrote:

Workbooks.Open Filename:="Jobs Data.xls"
This line executes but the next line which selects a sheet doesn't
Screen updating is True
--
none


"Bob Flanagan" wrote:

If you have Application.screenupdating = false in your macro, try removing
it. One of the subtle differences between stepping through a macro and
running it is that screenupdating is always on when you step through it. If
the macro is doing charting work, I have found that updating must be on or
else some charting commands will not work.

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"RHall" .(donotspam) wrote in message
...

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