Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A question regarding Macros
I was curious to know if there was an option to not show the work
macro button I recorded is doing. When you click the button the shee jumps around a lot and then stops. I would like it not even bothe jumping around and just stay showing one part of the excel sheet whil it does its work. If its possible please let me know! Thanks ERi -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
A question regarding Macros
Hi
add the following lines sub your_macro application.screenupdating=false 'your existing code application.screenupdating = True end sub Note: Though the macro recorder creates a lot of 'Select' statements they're in most cases not required but slow down your macro. e.g. a statement like the following: with activesheet Range("B1").select Selection.value="value" end with could be shortened to: Activecell.Range("B1").value="value" -- Regards Frank Kabel Frankfurt, Germany I was curious to know if there was an option to not show the work a macro button I recorded is doing. When you click the button the sheet jumps around a lot and then stops. I would like it not even bother jumping around and just stay showing one part of the excel sheet while it does its work. If its possible please let me know! Thanks ERic --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
A question regarding Macros
Typo alert...
I'm pretty sure that Frank meant: Activesheet.Range("B1").value="value" instead of: Activecell.Range("B1").value="value" Frank Kabel wrote: Hi add the following lines sub your_macro application.screenupdating=false 'your existing code application.screenupdating = True end sub Note: Though the macro recorder creates a lot of 'Select' statements they're in most cases not required but slow down your macro. e.g. a statement like the following: with activesheet Range("B1").select Selection.value="value" end with could be shortened to: Activecell.Range("B1").value="value" -- Regards Frank Kabel Frankfurt, Germany I was curious to know if there was an option to not show the work a macro button I recorded is doing. When you click the button the sheet jumps around a lot and then stops. I would like it not even bother jumping around and just stay showing one part of the excel sheet while it does its work. If its possible please let me know! Thanks ERic --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
A question regarding Macros
Thanks Dave
-- Regards Frank Kabel Frankfurt, Germany Dave Peterson wrote: Typo alert... I'm pretty sure that Frank meant: Activesheet.Range("B1").value="value" instead of: Activecell.Range("B1").value="value" Frank Kabel wrote: Hi add the following lines sub your_macro application.screenupdating=false 'your existing code application.screenupdating = True end sub Note: Though the macro recorder creates a lot of 'Select' statements they're in most cases not required but slow down your macro. e.g. a statement like the following: with activesheet Range("B1").select Selection.value="value" end with could be shortened to: Activecell.Range("B1").value="value" -- Regards Frank Kabel Frankfurt, Germany I was curious to know if there was an option to not show the work a macro button I recorded is doing. When you click the button the sheet jumps around a lot and then stops. I would like it not even bother jumping around and just stay showing one part of the excel sheet while it does its work. If its possible please let me know! Thanks ERic --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macros vba question | Excel Worksheet Functions | |||
Question on Macros | Excel Discussion (Misc queries) | |||
Question about macros. | Excel Discussion (Misc queries) | |||
Question about merging macros | Excel Worksheet Functions | |||
question macros | Excel Worksheet Functions |